AD 81-18-04 R2
Registered aircraft · 81,733
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:81-18-04-R2')
OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2')
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:81-18-04-R2') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:81-18-04-R2') 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.
N9371SRiley Loy D · Charlton, MAN9371VFly Me To The Mooney LLC · Owings Mills, MDN9371WRegistered aircraftN9372HN9372h LLC · Wilmington, DEN9372JReed Theodore W III · Trinidad, CON9372LBaugh Brett J · Jonesboro, ARN9372NAndys Auto Sales LLC · Caroline, WIN9372WVogler Michael John · Huntington Beach, CAN93730Pea-Wayman Flight LLC · Daytona Beach, FLN9373DWhite Matison R · Chugiak, AKN9373FDirty Side Down Aviation LLC · Georgetown, TXN9373MKelly Andrew J · Shirley, ARN9373SCentral Vermont Flying Club Inc · Williston, VTN9373VEl-Cheikh Taimour · Waldorf, MDN9373WBar Aviation LLC · Cochranville, PAN9374FPierson Robert N · Nora, MNN9374LMcmanus Keith S · Carlisle, PAN9374MRoberts Terry L · Bolt, WVN9374WMatthew John Stewart · Delaware, OHN9375BVinland Aerodrome Inc · Baldwin City, KSN9375CFucik John J · Reno, NVN9375JPanjab Aviation Inc · Las Vegas, NVN9375MSweeney David J · Portland, ORN9375NProffitt Albert E III · Warwick, RIN9375VDavis Wesley · Dayton, OHN9376JMorales Michael · Pembroke Pines, FLN9376LSchrick Robert B · Firth, NEN9376MBeans James B IV · Camas Valley, ORN9376TMosley Kenneth N · Westlake Village, CAN9377CLiggett Services Inc · Fort Washington, PAN9377HAir Advantage Inc · Mount Pleasant, IAN9377JDruetzler Thomas · Lynwood, ILN9377LLowry Joseph · Elizabethtown, ILN9377MFlying Cookies LLC · Lyman, SCN9377PBoehmer Richard P · Machias, NYN9377WDonley Brian J · Lafayette, INN9378DAndden Aviation LLC · Santa Monica, CAN9378JBentley Aero LLC · La Farge, WIN9378LQuigley Patrick M · Slidell, LAN9378MStratus Investment Corp · Lino Lakes, MNN9378VN83993 LLC · Cherry Hill, NJN9379Daghita Adam R · Colonial Heights, VAN9379HCitizen Air LLC · Port Angeles, WAN9379JDurango Air Services LLC · Wilmington, DEN9379NWinick Evan · Allentown, PAN9379WWenz Lawrence Joseph · Monroe, NYN937APerkins Robert R · Walnutport, PAN937ASGc Aviation Services-1 LLC · Miamisburg, OHN937DBSnyder Colin · Caledonia, MIN937DCCaledonian Aviation LLC · Raleigh, NC
Back to AD 81-18-04 R2