AD 84-10-01 R1
Registered aircraft · 20,486
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.
N1496CSbma Services LLC · Mcclellan, CAN1496MMustang Sally Aviation LLC · Camden, SCN1498MSoaring Utah Inc · Sandy, UTN1498SNull Perry D · Gallup, NMN1499SSkylane Pictures LLC · Los Angeles, CAN149CPCivil Air Patrol · Maxwell Afb, ALN149FCDepartment Of Agriculture And Consumer Services · Tallahassee, FLN149MEMccrary Mike M · Fairhope, ALN149TBonilla Jose · Pembroke Pines, FLN14BABurris & Macomber P L L C Trustee · Tucson, AZN14JEN14je LLC · White Springs, FLN14JMMckinstry Aviation LLC · Parker, CON14LVSmetana Louis V III · Blair, NEN14MDDaniel Development LLC · Durango, CON14NNAms Aviation LLC · South Bend, INN14PLByers Steven · San Diego, CAN14QWDinucci Mario · Auburn, CAN14VCG5 LLC · Gallup, NMN14YYNorthwoods Air LLC · Orono, MEN1500DMaxson Lee V · Mesa, AZN1501MMeszler Christopher P · Spring Branch, TXN1502DPaolucci Christopher J · North Olmsted, OHN1503UAmerican Jet Center Inc · Chino, CAN1505DPearce Cedric J · Chapel Hill, NCN1505TN1505t LLC · Tucson, AZN1506MBonn Steven · Hummelstown, PAN1508CHutchings Alan J · Clewiston, FLN1508FHaley Wayne C · Okeechobee, FLN1509CHammerquist Blake T · Benicia, CAN1509MChalk 2 Inc · Apple Valley, CAN150CACivil Air Patrol · Maxwell Afb, ALN150PNational Test Pilot School · Mojave, CAN150SCAnderson Thomas R · Seattle, WAN1511CBouton Vern H · Fairbanks, AKN1512CMolek Jon · Warren, OHN1512FJordan S G · Wasilla, AKN1513CSteffen Thomas E · Decatur, TXN1513DPeile Kelly T · Lakeview, ORN1514DPort Townsend Aero Museum · Port Townsend, WAN1514MVaquera Moises C · Orland, CAN1515CMountain Taildraggers LLC · Aspen, CON1515DHolmes John A Trustee · Glen Rose, TXN1515FCain Ronald A · Slidell, TXN1516CSpotorno John Alan · Redwood City, CAN1517FSalter 11x LLC · Duluth, MNN1517UN1517u LLC · Mequon, WIN1518DStegman Robert A · Saint Peters, MON1518UN1518u LLC · Waukesha, WIN1519CMinor Edward H · Gordon, NEN151BSEvans Linda J · North Wales, PA
Back to AD 84-10-01 R1