AD 94-05-05 R1
Registered aircraft · 26,230
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.
N99511Bartholomew William T · Louisburg, NCN99514Workman James E · Zanesville, OHN99518Coats Christopher R · Vinita, OKN99520Graham William T · Gilroy, CAN99530Hibler Kenith R · Newcastle, OKN99539Peppas George D Jr · Fort Wayne, INN99543Horne Lynn E · Adel, GAN99547Komara Lawrence · Fort Worth, TXN9954ANolen Donald F · Plano, TXN9955ANelson Harry J · West Bend, WIN99564Spiegel Darren J · Chicago, ILN9956YRkls Aviation LLC · Idaho Falls, IDN9957ADunn Ward A · Columbia, SCN9957YWilkes Jack M · Port Orchard, WAN9958AChase Kevin J · Anchorage, AKFirst renewal noticeN99591Olson Bruce I · Osceola, WIN99596Miller Steve L · Naperville, ILN99597Vardara Philip G · Penn Valley, CAN9959ANelson Jayson A Trustee · Caldwell, IDN995NABucher Devin V · Kalispell, MTN995PGPratt Mark J · Sikeston, MON9960YHeuer Daniel C H · Kindred, NDN99615Beyer Mark E · Towanda, KSN99618Lull William G · Ramona, CAN9961YSix One Yankee LLC · Rochester, MNN99622Gregory Vernon L · Swansea, SCN9962YRankin Paul D · Hudson, WIN99630Denniston John A · Albion, NYN99641Oltz Walter H · Sauk Rapids, MNN99642Roberts Raymond J · Rockledge, FLN99646Shuler Donald · Punta Gorda, FLN99649Taylor Edward J · Cedar Hill, TXN99657Newbury Dennis M II · Brea, CAN9965ARobertson Francis E · Hibbing, MNN99686Cullen Thomas E · Wakeman, OHN9968APickett Steven M · Odenville, ALN99698Beecher Dennis L · Martinsburg, PAN9969ARegistration Pending · Frostproof, FLRegistration pendingN996CAClassic Aircraft Investments LLC · Tega Cay, SCN996DWWallis David J · Salome, AZN996ERRomstadt Eric P · Oregon, OHN996RTrollinger Lari D · Wanette, OKN996TBEastman Brian R · East Hampton, CTN99703Treece Charles M · Morristown, TNFirst renewal noticeN99707Henk Edward W · Pine River, MNN9970AKingsley Kiman J · Miller, MON9970YWeisenberger Michael J · Norwalk, OHN9971AZilinsky Robert F · Willowbrook, ILN99729Arndt Eric A · Jacksonville, FLN9972ARegistration Pending · Seattle, WARegistration pending
Back to AD 94-05-05 R1