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.
N5751TGordon Robert A · North Pole, AKN57529Bauer Lawrence L · Grand Raids, MIN5752CNoyes Jeffery A · Bridgeport, TXN5752TStrahan Gary · Beaumont, TXN5755ABlue Sky Flyers Inc · Joplin, MON5755EWilken Christopher W · Milford, IAN5755REshbaugh Melvin L · Topeka, KSN5755TD2 Government Solutions LLC · New Bern, NCN57560Henley Mark L · Greenwood, MSN5756AKunz Isaac A · Texarkana, TXN5756CFly48north LLC · Lynden, WAN5756RCm3 LLC · North Las Vegas, NVN5757GWill Cutter G · San Angelo, TXN5757TFive Seven Tango Inc · Fitchburg, WIN5758CFour Mound LLC · Kennewick, WAN5759AFlying K & Associates Inc · Hawthorne, FLN5759EHarrison Gary L · New London, WIN5759RP & R Aviation LLC · Edenton, NCN575DWEastern Stearman Inc Trustee · Leesburg, VAN5760CHenson Robert H Jr · Lanark, ILN5760GVan De Walle Matthew W · San Antonio, TXN5762CColescott Zachary · Cleveland, TNN5763TLumgair David R · Painter, VAN5764AMorrison Benjamin F III · Godley, TXN5765CFinnegan John J · North Fort Myers, FLN5765GQuiring Jason L · Terrell, NCN5765TRawareo LLC · Warsaw, MON5766ASoma Holdings LLC · Wasilla, AKN5766CMacgregor David A Jr · Naples, FLN5766TJanson Flying Service Inc · Wadena, MNN5767RSelf Averill L · Campbell, TXN5768AGowing Glyn Thomas · Longview, TXN5768CJones Gary A · Huron, SDN5768DOdonnell Daniel V · Dover, DEN5768GBilton Nicholas J · Bozeman, MTN5768RAllenray Corp · Otsego, MIN5768TCrouse Sheldon · Mount Pleasant, NCN5769DLange Keith J · Merrill, WIN5769GHarper William M Jr · Foley, ALN5769RLatimer Francis E · Washingtonville, NYN5770EEagle Aviation LLC · Spearfish, SDN5770GVoller Jim A · Strasburg, NDN5770RFurge David T · Brookton, MEN5771AHunt Jack D · Wilmington, NCN5771RWilson Bach Myrl · Piedmont, SCN5772ALawlor Stephen M · Saint Joseph, MON5772GBean Dale R · Moreno Valley, CAN5773AMelton James A · Mayflower, ARN5773DGolden Arrow Aviation Inc · Wilmington, DEN5773REnev Ivan E · Wood Dale, IL
Back to AD 94-05-05 R1