AD 72-08-06
Registered aircraft · 10,639
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:72-08-06')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-08-06')
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:72-08-06') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:72-08-06') 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.
N1185XWilliamson Flying Club Inc · Williamson, NYN1188TAbrams Jeffrey Scott · Phoenix, AZN1196XMedic Choppers LLC · Springdale, ARN1198XDiscover Aviation Center LLC · Elyria, OHN119A2is Partners LLC · Vero Beach, FLN119HPValiair Limited Company Trustee · Casper, WYN119JDUSA Wiltshire LLC · Pembroke Pines, FLN11GERusso James F · Liberty, SCN11GKBaden Michael · Waxhaw, NCN11GNHaley James M Trustee · Edmond, OKN11HAVintage Aero Inc · Brandon, FLN11KAlbers Edward C · Burlington Flats, NYN11LYBishop Jay K · Columbus, INN11NTSabb Anthony · Wetumpka, ALN1203TProfessional Locators & Acquisition Specialists Ll · Severance, CON1204THigh Sky LLC · Ellensburg, WAN1205TAmerican Aircraft Management LLC · Irving, TXN1206TCps 1 LLC · Pelham, ALN120DMWestfall Aviation LLC · Reno, OHN1213TDyer Gary T · Reno, NVN1214TPost 8 Flight Opps Inc · Topeka, KSN121ESWell Bilt Industries USA LLC · Ocala, FLN121HEJarrett Air LLC · Ashland City, TNN121MDBaggarly Michael · Newnan, GAN121SClark William H IV · Thurmont, MDN121TCDonney Tom J · Sturgis, SDN1226TLinde Glenn F Jr · Juneau, WIN122HSMarbury Sherri E · Jackson, TNN122KTRustair Inc · Anchorage, AKN122TEBouchillon James R · Hanahan, SCN1232TAlexander Charles W · Slidell, LAN1235SBarney Erick L · Jacksonville, ORN1237HGivens Timothy A · Collierville, TNN123BEBald Moutain Aviators · Fredericktown, MON123GEFlying Four Inc · Saint Petersburg, FLN123JCDippolito Mario M · Sherwood, ARN123LUSutton Aircraft Salvage LLC · Palmer, AKN123MFAronhalt Daniel E · Columbus, INN123SWBelschner Custom Meats · Amherst, NEN123TXGofly Corporation · Port Ewen, NYN123YAAircraft Guaranty Corp Trustee · Oklahoma City, OKN1241TGale Richmond T · Tewksbury, MAN1242TDoblmaier Thomas J · North Wales, PAN1246TRegistration Pending · Fort Mc Coy, FLRegistration pendingN124JCDestination Aviation LLC · Destin, FLN1250TStanley Natasha S · Lorton, VAN1251TMcvey Cindy M · Colts Neck, NJN1260TRed Rock Flying School LLC · Mesa, AZN1261TObrien Timothy D · Alplaus, NYN1264THolloway Andrew F · Woodville, TX
Back to AD 72-08-06