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.
N30117D & S Aviation LLC · Spring, TXN3011FGordon Air Services Inc · Miami, FLN3011KBravo Farm LLC · Dover, DEN3011NLange Jonathan R · La Mesa, CAN3011WHall Larry C · Decatur, ALN3011XHanania-Stout Motorcars LLC · Chattanooga, TNN3011YStrategic Sourcing Solutions Inc · Topeka, KSN3011ZBoe Arvid J · Langdon, NDN30126Pilots Choice Aviation Equipment Leasing Co · Georgetown, TXN30128Mizani Air LLC · San Antonio, TXN3012ABottoms Engineering & Service Inc · Frankfort, KYN3012BThrowbacks LLC · Pueblo, CON3012CHealy David Paul · Arlington, TXN3012DArias Herman R · Waco, GAN3012EDamschroder Rex A · Fremont, OHN3012HBonanza Two USA Inc Trustee · Wilmington, DEN3012LCwp Flight LLC · Lawton, OKN3012NBirkenseer James J · Danville, CAN3012ZChase 13 LLC · Wilmington, DEN30133Ts Fliers LLC · Mount Pleasant, MIN30139Heinitz Bradford C · Arlington, WAN3013DMcclary Doug T · South Lyon, MIN3013FElwell David L · Coolidge, AZFirst renewal noticeN3013NAnderson John · Hollister, CAN3013YHolloway Gregory R · Brenham, TXN3013ZZakos Dean R · Middleton, WIN3014B-Line Air LLC · Malcom, IAN30142Marshman Robert M · Murfreesboro, TNN30145Keno Aviation LLC · Marshfield, MAN30147G&M Aircraft Inc · Wheat Ridge, CON30148Tyler Marion B · Lacey, WAN3014EConstantine Carl A · Arroyo Grande, CAN3014FBrown Kimberly L · Tucson, AZN3014GWings Aircraft LLC · Anacortes, WAN3014HBad Dog Aviation Inc · Meridianville, ALN3014MBaum James L Trustee · Anchorage, AKN3014QBilly B Services LLC · Cornelia, GAN3014WRunyan Joseph D · Bushnell, ILN3014XReasoner Michael L · Corvallis, ORN30151Miller Jacob G · Harrison, ARN30153Waters Donovan D · Peoria, AZN30157Cardinal Aviation LLC · Pelham, NHN30158Segroves Jeffrey S · Milledgeville, GAN3015CSorna Douglas J · Flower Mound, TXN3015DFlywell Flying Club Inc · Roseville, MNN3015ECuevas Ernesto · Orlando, FLN3015GParatus Air Inc · Auburn, INN3015UCoastal Fliers Inc · El Cajon, CAN3015WDl321 LLC · Lavon, TXN3015YBaines Larry R · Antioch, CA
Back to AD 2007-04-19 R1