AD 94-05-05 R1
Registered aircraft · 26,232
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:94-05-05-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:94-05-05-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:94-05-05-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:94-05-05-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.
N63641Cole Warren G · Watkinsville, GAN63645Greene Roswell J · Punta Gorda, FLN63646Reed Phillip · Lanesboro, MNN63647Appalachian Wings LLC · Ellijay, GAN6364GCarlstadt William A · South Bound Brook, NJN6364VGregory Vernon L · Swansea, SCN63650Crain Charles E III · San Antonio, TXN63651Agricola Joseph D · Brooksville, FLN63652Tyndall Darryl K · Deep Run, NCFirst renewal noticeN63653Coker Steve L Jr · Tyler, TXN63655Van Houten Ronald G · Kalamazoo, MIN63657French Chris · Anchorage, AKN6365GN6365g LLC · Buckeye, AZN6365KSchlueter Wayne J · Andover, KSN6365VHoskins Marc R · Kennett, MON63662Gessert Adam K · Gilbert, AZN63664Cabrera Ramon F · Guttenberg, NJN63665101 Flight LLC · Waterford, MIN6366GTownson Charlotte K · Cisco, TXN6366KCastano Jose R · Sleepy Hollow, NYN6366VCombs Ronnie M · Albany, MON63670Uflyorlando Corp · Wilmington, DENon-citizen corporation, flight hours not reportedN63671N63671 LLC · Austin, TXN63677Weir Ryan Lee · Buckley, WAN63679Goldman Jacob · Bend, ORN6367KPethes Ted · Las Vegas, NVN6367SLogtime Flight LLC · Lancaster, TXN6368SMommsen Robert V · Ketchikan, AKN6369ETeed Brad S · Vancouver, WAN6370VWhite Berry · Runaway Bay, TXN6371EPrincy Lala · Deltona, FLN6372TBehr Casper J · Neavitt, MDN6372VWhitcomb Keith R · Villa Rica, GAN6373VKaichen Michael Trustee · Eliot, MEN6374GLilbit Industries LLC · Oklahoma City, OKN6375EDial Eric A · Eldon, MON6375VBarker Benjamin J · Pittsburg, NHN6376EZawacki William M · Medford, WIN6377SVillalba Raymond · Spring, TXN6378GHigh Exposure Inc · Wilmington, DEN6379SMcdonald Gregory S · Mena, ARN637LSButts Michael P · Dartmouth, MAN6383KMock Joseph R · Huntsville, TXN6383SNightingale Matthew · Rancho Cucamonga, CAN6384HFridley Mark R · Indianola, IAN6384SSalter William Jeffrey · New Smyrna Beach, FLN6385ELucky Dog Land Co LLC · Caldwell, IDN6385SPalmer Dana G · Gatesville, TXN6386GSonafrank Eric · Somerset, INN6387HFisher Ty N · Hardin, MT
Back to AD 94-05-05 R1