AD 94-05-05 R1
Registered aircraft · 26,231
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.
N42JCStevens David L · Richmond, INN42KHo Christopher Y · Anchorage, AKN42RPCallahan Jr Ted F · Magnolia, TXN42SJN42sj LLC · Ann Arbor, MIN42XPNewbold Edward F · Galloway, OHN43006Spencer Daniel P · Cocolalla, IDN4300CBerke Steven M · Black Hawk, SDN4300NNotaras George John · Manhattan Beach, CAN43015Dayton Kenneth J · Great Mills, MDN4301BCff LLC · Kalispell, MTN4301HDrane Stephen T · Kerrville, TXN43021Hensel Brian D · Wasilla, AKN4302LSenn Steve E · Burwell, NEN4302ULarson Gary L · Elgin, TXN4303BWetherbee Michael · Howell, MIN4303CWhite David W · South Fulton, TNN4303LArtic'S Air Academy LLC · Palmer, AKN4303USherbak Michael J II · St Helena Is, SCN4303YLopez Richard · Hialeah, FLN4304UStoller Aircraft Rentals LLC · Sharpsburg, GAN4305EKlos Jeff · Plevna, MTN4305LLavin Renaye K · Wasilla, AKN4306CHarsh David L · Daniels, WVN4306LGrandinetti Robert L · Fayetteville, NYN4307HEmerson Tiffany A · Roseville, CAN4308BLyons Milo J · Sequim, WAN4308CBrooks Clifton B · Harrah, OKN4308HLeaders Bob O · Clear Lake, MNN4308LKim Jingu · Mount Prospect, ILN4308UWildcat Aviation LLC · Schoolcraft, MIN43096Kornfield Edward A · Anchorage, AKN4309LWallace Leroy C · Wshngtn Ct Hs, OHN4310BMaly Burr J · Anchorage, AKN4310CTadic Michael · Skagway, AKN4310EDittlinger Bret W · Anchorage, AKN4310LMckenzie Donovan G · East Northport, NYN4310USport Wings Enterprises LLC · Pasadena, TXN4311BPohl Jeffrey A · Milaca, MNN4311CPage Aerial Service Inc · Rochelle, ILN4311EHeavirland Robert A · North Branch, MNN4311LRockin Robin Aviation LLC · Natchez, MSN4313CJohnson Charles M · Malta, MTN43143Andrews Jon L Jr · Seward, AKN4315Kimbrel Martin E · Oakville, WAFirst renewal noticeN4315BMckamey Dave S · Sonora, CAN4315LBeedle Jeremiah J H · Juneau, AKN4315UYoung Margaret J · Peck, IDN4316BAnderson Gregory P · Meadow Vista, CAN4316CNorman Shawn T · Rothsay, MNN4317CSasinowski Joseph Vance · Anchorage, AK
Back to AD 94-05-05 R1