AD 84-10-01 R1
Registered aircraft · 20,483
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.
N2833CKizer Charlene A · Albany, ORN2833RRegistered aircraftN2833YLancaster Mark E · Buffalo, SCN2834ADalton John B · Dallas, ORN2834COsborne David A · San Antonio, TXN2834RPence Levi B · Quincy, CAN2835AAllen Airplane LLC · Durango, CON2835EGonzalez Roberto Jr · Madera, CAN2835FAdams Stephen L A · Fortuna, CAN2835KGardner Thomas W · Lincoln, MEN2835YRafter S Contractor Services LLC · Cuero, TXN2836ABond Darren R · San Antonio, TXN2836FPaul Jr Johnny D · Camden, SCN2836RWorthington David C Trustee · Saratoga, WYN2836YAyers Janet S · London, KYN2838KOrtman James W · Bozeman, MTN2838RFairbanks Mark J · Kotzebue, AKN2839AAldrich David S · Unity, MEN283LPPecue Michael T · Mount Dora, FLN283RDBengtson Douglas Richard · Woodinville, WAN283TBNance Joseph W · Fort Collins, CON2840FMendive Richard J · Priest River, IDN2840YMcdonald Kelly · Amity, ORN2841FDrago Gene Kirk · Bainbridge, GAN2842FKuhns Robert A Trustee · Geneseo, ILN2843AKnerr Joshua DBA · Tehachapi, CAN2843RDrandike Aviation LLC · Scottsdale, AZN2843YHarper Fred S · Springerville, AZN2844ASmith Jon K · Adairville, KYN2844FN2844f LLC 0421 · Valentine, NEN2844YChildress Hugh W · Ozona, TXN2845RCarlson Kevin J · Dunedin, FLN2846FA-Z Aviation LLC · Bay City, MIN2847AKozacek Carter A · Duluth, MNN2847RCashman Jeremiah P · Bozeman, MTN2848ALitzen Guide Service Inc · Kenai, AKN2848KNeuwirth Gerald F Trustee · Lawton, OKN2848RBoccaccio Peter A · Burke, SDN2849AMettler James T · Camas, WAN2849FPrice Marvin H · Roseburg, ORN2849KWarren Mark W · Arlington, WAN2849RKoehler Paul Jeffrey · Perkasie, PAN2849YZimmerman Leonard R · Middlebury, INN284CSSc Aviation LLC · Manhattan, KSN2850ASnyder Jason D DBA · Oakland, MDN2850FGozansky Elliott K · Birmingham, ALN2850RNorcal Skydiving LLC · Cloverdale, CAN2851RRegistered aircraftN2851YColdwell Samuel L · White Pine, TNN2852FLane Jeffrey A Trustee · Elm Grove, WI
Back to AD 84-10-01 R1