AD 2007-04-19 R1
Registered aircraft · 108,434
Registered aircraft whose airframe or engine model this AD names, by N-number. Matched by model only, so check each against the AD’s applicability.
Query with SQL
duckdb -csv -c "SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state
FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet'
WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1')
ORDER BY n_number"Prints the whole list as CSV. It reads the release’s Parquet files over HTTPS, so there’s nothing to download first. Install DuckDB to run it.
SELECT n_number, serial_number, year_manufactured, status, aircraft_model_code, engine_model_code, registrant_name, registrant_city, registrant_state FROM 'https://openairdocs.org/data/latest/faa_aircraft_registration.parquet' WHERE aircraft_model_code IN (SELECT aircraft_model_code FROM 'https://openairdocs.org/data/latest/faa_aircraft_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2007-04-19-R1') ORDER BY n_number
Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.
N3850YPoole Vernon N · Melstone, MTN38513J&L Aviation LLC · Wilmington, DEN38517Stillway Dennis Trustee · Vallejo, CAN3851CAbb Aviation LLC · Burnsville, MNN3851DSale Reported · Darby, MTSale reported, pending cancellationN3851LFreedom Aviation Of Ne Florida LLC · Jacksonville, FLN3851PHulsey Johnathan J · Wasilla, AKN3851RIriana Arthur · Palmdale, CAN3851TSkyview Aviation LLC · Tracy, CAN3851YMckie-Voerste Travis K · Chatsworth, GAN38522Radcliffe Joshua Kyle · Atlanta, GAN3852CWilson Kirk B · Glennallen, AKN3852QOwens Wilbur · Rch Palos Vrd, CAN3852TB & B Aircraft LLC · Norcross, GAN3852WHaymond David G · Sandy, UTN3853DMccabe Ryan · Las Vegas, NVN3853G3853g LLC · Umatilla, FLN3853JMitchell James R · Anthem, AZN3853PLambert Aviation LLC · Charlotte, NCN3853RDimichele James Jr · Ronkonkoma, NYN3853XStangel Eric K · Enterprise, ORN3853YRafter Bar B LLC · Ashland City, TNN38549Cohesive Aviation LLC · Gilford, NHN3854CAnderson Clint T · Corsicana, TXN3854DTjp@Jax Inc · Zephyrhills, FLN3854GDry Creek Aviation LLC · Belmont, CAN3854PBall Logan T · Dillingham, AKN3854QHafford Jay T · Stevenson, WAN3854WValiair Lc Trustee · Casper, WYN3854XApplegate Ronald E · Rosamond, CAN3854YJames Wilson Smith Enterprises LLC · Athens, GAN3854ZWarren Air LLC · Turner, MTN38553Cherry Hill Aviation Inc · Freetown, INN3855GMoore David · Lexington, TXN3855MPramik Edward J · Norton, OHN3855PGriffith Jacob C · Bedford, PAN3855TEskridge William M · Cheraw, SCN3855WRcr Aviation LLC · Punta Gorda, FLN3855ZPennison Scott J · Nikiski, AKN38562Adventures Awaiting LLC · Rogers, ARN38564Ck Leasing Services LLC · Wilmington, DEN38565Olson Michael S · Ellsworth, KSFirst renewal noticeN3856TB & B Flying LLC · Huntingburg, INN3856WBarr Barry · Memphis, TNN3856XIce Cody W II · Houston, MON3856ZRed Cub LLC · Wilmington, DEN38570Dm Asset Management LLC · Plain City, OHN38575Hieb Jared · Amarillo, TXN38577Global Aviation Corp · Farmingdale, NYN38578H & H Contracting And Lease Services Inc · Midlothian, IL
Back to AD 2007-04-19 R1