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.
N2360GVath Edward V · Acton, CAN2361GMcmanigle Jeffrey M · Osakis, MNN2362CCelek Brian F · Charleston, SCN2362JBauer Bryce · Forestville, CAN2362RBarone Christian · Stratham, NHN2362XFort Scott Family Medicine Pa · Fort Scott, KSN2363FColumbus State Community College · Columbus, OHN2363GSawaya Mark C · Spring Valley, CAN2363RVertikle Enterprises LLC · Cheyenne, WYN2363S182 Skylane LLC · Loxahatchee, FLN2363XShort Joe · Clintwood, VAN2364CMeinershagen Charles I · Redding, CAN2364FCarlson David G Trustee · Cape Fair, MON2364GTveitnes Svein T · Whitewright, TXN2364RRegistered aircraftN2364XElkhorn Aviation LLC · Norfolk, NEN23655Redline Aviation LLC · Wilmington, DEN2365CStrolin LLC · Maple Valley, WAN2365NDulles Aviation · Bristow, VAN2366CKase Gayle L · Wasilla, AKN2366EWerner Service & Trucking Inc · Saint Edward, NEN2366GDelaware Aircraft Trust LLC Trustee · New Castle, DEN2366MWestbank Fishing LLC · Kiln, MSN2366NKohnen Patrick Kennedy · Flagstaff, AZN2366YAvco Patrol LLC · Lyndon, KSN23676A&E Flying Club Of Los Angeles Inc · Hawthorne, CAN23677Doering Jim · Arcadia, CAN2367GSahagun Salvador G · Bothell, WAN2367MPeterson Aviation LLC · Oregon, WIN2367X182 Jkp LLC · Fall River, MAN2368GRegistered aircraftN2368SShane LLC · Wilmington, DEN2368XD C T LLC · Wallace, IDN2369CBlackert Charles M · Delaware Water Gap, PAN2369GPeter Travis E · Casper, WYN2369KMgm Aviation LLC · Montara, CAN236AMyotis Ltd · Leesburg, VAN236AGTroposphere Ventures LLC · Fond Du Lac, WIN236RCCarter Rodney D · Artesia, NMN2370EPowers Thomas Jr · Westerly, RIN2370GJ H Nicklas Inc · Cartersville, GAN2370WSall LLC · Mill Valley, CAN2371CMathers John R · Denton, TXN2371RBudell Stacey M · Caldwell, IDN2371XCouch Sue A · Dewy Rose, GAN2372CMartin Land Improvement Inc · Elk Rapids, MIN2372GJohnson David B · Santa Barbara, CAN2372XRegistered aircraftN23735Leighton Farms Ltd · Griswold, IAN2373CDs Flight Services LLC · Battle Ground, WA
Back to AD 84-10-01 R1