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.
N3043SSpitler John · Laramie, WYN3043XVaughan John T · Safety Harbor, FLN30440Tsidjs LLC · Lehighton, PAN30448Jackson James E · Brainerd, MNN3044GBusby Kristina · Port Saint Lucie, FLN30455Davidge William B · Winlock, WAN3045UAfterburner Aviation LLC · Lewes, DEN3045VBuck Quincy M · Lakeville, MNN3046AKoelsch Anthony W · Anchorage, AKN3046GSale Reported · Decatur, TXSale reportedN3046JDyer David A · White Hills, AZN3046SWhite William E · Watkinsville, GAN3047HRosenfeld Charles L · Sunriver, ORN3047NStagnito Kollin · Frederick, MDN3047SBarrons Aviation Services LLC · Henderson, NVN3047XSmith Richard D DBA · Williamstown, OHN3048ADorr Eric J · Piseco, NYN3048GJohnson Linzy A · Lake Stevens, WAN3048JBrown Theodore L Jr · Fort Worth, TXN3048SFlight Expo Inc · Princeton, MNN3048XVisconti Phillip M · Hominy, OKN3049GPrentice Robert D · Ripon, WIN3049HPressly James P · Lake Wylie, SCN3049JRound Engine Aero · Nashville, MIN3049NAyres Henry W Jr · Marshall, VAN3049SGenthner Scott A · Milo, MEN3049UHillberg Roger J · Crandon, WIN3049VCraig Dennis M · Yukon, OKN304SGSierra Golf Aviation LLC · Albuquerque, NMN30508Byars Guy F · Goshen, OHN3050ABlock Harlan T · Carthage, MON3051VMeyette Alexzander · Montague, MIN3052GCullen Nancy J · Wichita, KSN3052U6m Aviation LLC · Pleasant Hill, MON3053SStelling Kurt · Newnan, GAN3053UJ & T Aviation LLC · Nashua, NHN3053XVoigt Richard D · La Vernia, TXN3054XHeidt Daniel A · Opelika, ALN3055ABohl Howard M · Temecula, CAN3055GFlying Colors Airparts Inc · Leesburg, FLN3055XChickasha Wings Inc · Chickasha, OKN3056GLacombe Thomas D · Tahlequah, OKN3056JRegistration Pending · Jackson, MIRegistration pendingN3056NDeaton Christopher D · Biloxi, MSN3056USchans Richard L Sr · New Bern, NCN3056XSmith Chelsea R · Louisville, KYN30576Keeline Robert G · Palo Cedro, CAN3057JGaines Von J · Hendersonville, TNN3057KPhillips Brandon · Atmore, ALN3057SMcabee Patrick A · Tampa, FL
Back to AD 94-05-05 R1