AD 98-21-21 R1
Registered aircraft · 85,612
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:98-21-21-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:98-21-21-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:98-21-21-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:98-21-21-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.
N305GTomahawk Aviation LLC · Reno, NVN305GDGlyn Dwr Air LLC · Kalispell, MTN305GGChayes Daniel A · Mercersburg, PAN305HStat Care Clinics LLC · Baton Rouge, LAN305JBKoning Ryan W · Williams, AZN305JCAccurate Aero LLC · Minden, NVN305JKOrcutt John Edward · Tucson, AZN305JTWinniwolfe Holdings LLC · Wolfeboro, NHN305KFlorida Flying Tigers LLC · Tampa, FLN305KMKeim Jeffrey R · Moorhead, MNN305KWPumpkin Eater LLC · Tavares, FLN305L305l Air Holdings LLC · Phoenix, AZN305LSHill Karin V · Georgetown, TXN305LWProfessional Flyers Corp · Wilmington, DEN305MHartley John · Kissimmee, FLN305MCShen Air II Inc · Mount Crawford, VAN305MDPiper Aircraft Inc · Vero Beach, FLN305MKCoughlin Enterprises Inc · Central Point, ORN305MMSegal Marshall B · Chicago, ILN305NDUniversity Of North Dakota · Grand Forks, NDN305NHRoesch John M · Largo, FLN305PE305pe LLC · Lakewood Ranch, FLN305PFSale Reported · Crystal, MNSale reportedN305PJBradley Alana J · Joliet, ILN305PRGlahn Guy R · Redmond, ORN305PTCappe Investment Group LLC · Homestead, FLN305REasterling William D · Salisbury, NCN305RDSouthern Aircraft Consultancy Inc Trustee · Casper, WYN305RKRegistration Pending · Gilbert, AZRegistration pendingN305RMPuglielli Jeffrey W · Bolingbrook, ILN305RTMorris Alysse · Rapid City, SDN305SESouthern Aircraft Consultancy Inc Trustee · Casper, WYN305SLSealand Airways Miami LLC · Miami, FLN305TCjn Enterprises LLC · Elbert, CON305TBExecutive Aeronautical Group LLC · Pensacola, FLN305TJSenninger Thomas P · Clermont, FLN305UMParagon Airplane Leasing Co · Fort Myers, FLN305VPGaskins Patrick A · Fort Lauderdale, FLN305WBCardinal Aviation LLC · Charles City, VAN305WP3192 Golf Inc · Wauchula, FLN305WRKnudsvig Travis · Waterloo, IAN305WWObrien Aviation Inc · Port Orange, FLN305XXDs Group LLC · Miami, FLN305YWRichard L Richards P A Trustee · Coral Gables, FLN305ZReid William R Jr · Clarksburg, WVN30602Reinert Joseph M · Ringgold, GAN30608Christiansen Aviation LLC · Wilmington, DEN3060BPrestige Worldwide Aviation LLC · Downers Grove, ILN3060FEl Paso Aero Inc · El Paso, TXN3060LLang Scott T · Waseca, MN
Back to AD 98-21-21 R1