AD 84-10-01 R1
Registered aircraft · 20,481
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:84-10-01-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:84-10-01-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:84-10-01-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:84-10-01-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.
N8136MTakeair LLC · Incline Village, NVN8137GTwo Ten K LLC · Upper Sandusky, OHN8137LShreve Jerry · Warrensburg, MON8137ZSullivan Harry Stuard Trustee · Banning, CAN8138GRab Com Limited · Hayward, CAN8139LWashburn Kyle A · Yukon, OKN813CPCivil Air Patrol · Maxwell Afb, ALN813DMAp-1 LLC · Newman Lake, WAN813HCGeorgia Forestry Commission · Macon, GAN813PKN813pk LLC · Columbia, MON813SWWolff Scott · Missoula, MTN8141GBitter Creek Investments LLC · Cascade, IDN8142ZHayes Allen D · La Grange, KYN8143GRegistration Pending · Sparks, NVRegistration pendingN8143ZMoojens LLC · San Carlos, CAN8146QOak Gulch LLC · Killdeer, NDN8149MMcinnish John · Tallassee, ALN814JHOcean Ave LLC · Mound House, NVN814WMLannom John Rusty · Lebanon, TNN8154ZTurner Company LLC · Hearne, TXN8159MHowell Andrew · Pinedale, WYN815CPCivil Air Patrol · Maxwell Afb, ALN815DZBlue Sky LLC · Overland Park, KSN815GKN114jr LLC · Parrish, FLN81631Kelly Jon B · Anchorage, AKN8165ZHenry Kenneth S Trustee · Kingman, AZN8166ZBronson Robert D Trustee · Prineville, ORN8167QCedar Pine Construction Inc · Sturgis, SDN81689Feisthamel Robert R · Mount Vernon, MON8169VNelson Robert L · Fargo, NDN816CPCivil Air Patrol · Maxwell Afb, ALN816FATemm 2000 Inc · Arcola, ILN816JHIndy Aviation LLC · Carmel, INN816TRGood Day Holdings LLC · Sheridan, WYN816TXDavis Derek P · Sebastian, FLN817Naumann Scott Trustee · Arroyo Grande, CAN81708Adventist World Aviation Inc · Wilson, NCN8170ZJones Kevin C · Leander, TXN8174ZBishop Ronald E · Rolling Hills, CAN8177ZWilliams Dutch R · Mohave Valley, AZN8178ZCameron Joseph · Tucson, AZN817CPCivil Air Patrol · Maxwell Afb, ALN8180Wayman Daniel M · Medford, ORN8180ZAikins Nicholas O · Renton, WAN8182ZWolf Richard Cory · Syracuse, UTN8183MHaman Peter A · Douglas, WYN8185GJohnston John Lane · Houston, TXN8185ZViele Mark C · Buckley, WAN8186ZBernard David John · Damascus, MDN8187MMoose Eddy · Tyler, TX
Back to AD 84-10-01 R1