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.
N26BFBasco James Millard M · Richlands, NCN26CCook George W · Austin, TXN26DDHouse Jerry D · Odessa, TXN26ECOneil Thomas E · Salem, OHN26FSRenwick Andrew J · Senoia, GAN26GSEaton James Steven · Bristol, RIN26HTBluetail Aviation LLC · Olive Branch, MSN26LCRa Case LLC · Fort Pierce, FLN26LDTryon Roger C · Monterey, MAN26LTThistlethwaite Lex · Sunset, LAN26SXEwing Thomas C · Naples, FLN26TLHester Stanley D · Milton, FLN2700HBousquet Arthur David · Highgate Center, VTN2700KManning Arlen B · Napa, CAN2700LFly First LLC · West Memphis, ARN2700NDague James L · Kewanna, INN2700UMinier Manuel · Kissimmee, FLN2701KWoelbing Aviation LLC · Franksville, WIN2701LRegistration Pending · Los Angeles, CARegistration pendingN2701SLeavitt Mark Richard · La Verkin, UTN2702CThreadgill Stephen W · Lexington, TNN2702NKane Christopher M · Montevideo, MNN2702ULeatherwood Vaughn L · La Place, LAN27033Hill Judith L · Carriere, MSN2703CArvidson Donna E · Brighton, MIN2703WWilliams Richard P · Salmon, IDN27048Trissell Flying Service · Clarksville, TXN2704CNeary Russ P · Plympton, MAN2704LAgrifoglio Douglas · Reedley, CAN27051Geisler Mark C · Dallas, TXN27059Confederate Air Inc · Tillar, ARN2705SCarter James E · Thornville, OHN2706SWings With The Word · Sanford, MEN2706UHoelsch Shawn C · Livermore, CAN2707CPlane Fun Inc Tr Trustee · Snellville, GAN2707NLarsen James A · Minot, NDN2707UHills Holding · Newark, DEN2708NGoldstein Michael F · Medina, OHN2709ANorth Carolina Aviation Museum And Hall Of Fame · Asheboro, NCN2709CKyzer David D · Anchorage, AKN2709LGuideair LLC · Eden Prairie, MNN2709NFannin Warren Haukland · Yulee, FLN2710AMakely Abraham M · Culpeper, VAN2710CFrazier James C · Hinesburg, VTN2710UCape Aerial Tours DBA · Chatham, MAN2711CHolly Shawn L · Soldotna, AKN2711DSpinner James C · Belleville, ILN27123Hollingsworth George S · Finley, TNN27127Registered aircraftN27128Coberly Ryan · Seminole, FL
Back to AD 94-05-05 R1