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.
N40916Mt Air LLC · Erie, CON40924Grangruth Rory A · Wadena, MNN4092UBerthe Thomas A · Burlington, VTN4092VGroves Donald L · Butler, PAN4093JGarcia Joseph Donald · Okeana, OHN40947Simonson Larry A · Dalton, MNN4094EScholl Carl W · Borrego Springs, CAN4094JSquires Janis R · Amherst, OHN4094VGoodwin Jefferson J · Dolan Springs, AZN4095JParks Richard C · Salem, MON4095NWeaver Al C · Eagle Nest, NMN4096FGood John G · Weatherford, TXN4097FWadsworth Tom R · Roswell, NMN4097UJ & K Flying LLC · Marengo, OHN4098EMaltz Lawrence · Georgetown, TXN4098JFrench Darrell L · Easton, MDN4098VQualitair LLC Trustee · MichelstadtN40CWright Cecil A · Sanford, FLN40LCMckinney Brian M · Lakeville, MNN40LRRutan Aircraft Flying Experience · Waller, TXN40SDFlying S Airventures LLC · San Antonio, TXN40WLBentley Thomas F · Lockport, ILN41004Barton Bruce N · White Hills, AZN4100AWright David W · Moultrie, GAN4100VSanders Keith · Palm Bay, FLN41014Hainline Thomas D · Friendswood, TXN4101FHanson Kathleen A · Wasilla, AKN41025Loftin Kenneth G Jr · Sumrall, MSN4102ABeebe Eric P · Kinderhook, NYN4102FAdams Samuel M · Anna, TXN4102NWalden Taylor G · Pueblo, CON4103A501st Flight Solutions LLC · Kaysville, UTN4103VMoore Israel · Pasco, WAN4104EFlint Gregory C · Bristol, CTN4104FMcmahon William F · Westville, INN4104NQualitair LLC · MichelstadtN4104UJennett Christopher S · New Port Richey, FLN4104VDavis Lawrence R · Kent, OHN41051Haynes Thomas E · Avon Park, FLN41052Tippett Charles S Jr · Warrenton, VAN4105EPalmer Matthew B · Riverside, CAN4106LHackens Bryan Jay · New Underwood, SDN4107LRobitaille Charles · Stephenville, TXN41083Baker Thomas W · Mulberry, INN4108LCriss Mark · Eaton Rapids, MIN41095Yandik Stephen E · Hudson, NYN4109LMarrian Jason · Westtown, NYN4109UFratangelo Robert A · Sodus, NYN410DWWest Earl W · Canton, TXN410KTKing Terry F · Fort Denaud, FL
Back to AD 94-05-05 R1