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.
N7502UStirm Brian H · Delphi, INN7502XSnyder Mitchell R · Collierville, TNN7503BSale Reported · Rigby, IDSale reportedN7503MJudie Bear Air LLC · Bend, ORFirst renewal noticeN7503THutchison Greg A · Moses Lake, WAN7503XLamb Barry · Moran, KSN7504CSmith Douglas B · Channahon, ILN7504XMilnor Aviation Inc · Milnor, NDN7505GRandall James E · Villa Park, CAN7505XCrumpacker John E · Timberville, VAN75064Turner Steven C · Hastings, FLN75066Bryant Lee E · Frankston, TXN75067Kennelly Kevin T DBA · Fort Lupton, CON75069Chappell William L · Hertford, NCN7506BDoeden Bridger J · Miles City, MTN7506TLeblond Robert F · Wardsboro, VTN7506XRenquist John H · Valley Center, CAN7507BSalzman Michael · Milford, NHN7507EBall Robert L · Clinton, OHN7508BCrane Kenneth W · Oak Ridge, TNN7508CPhilip Sims · Otis, CON7508TJasmer Steven M · Randle, WAN7508XBain Sterling C Jr · Alexandria, LAN7509TMickelson Jason R · Shelton, WAN7509XRussell Adam · Easton, MEN750BJOrton Carl F · N Richland Hills, TXN750BKBoone Thomas D · Avon, ILN750BRBragg Jacob J · Sidney, MEN750BSHill Jonathan T · Taylorsville, KYN750CLLoy Howard J · Beaverville, ILN750DYCauffield Robert A · Marietta, GAN750JCChevalier Jean-Paul · Tijeras, NMN750JHClassic Aero Agricultural Corp · Aguada, PRN750JSSparks Timothy J · Jackson, MIN750LESoutheast Lsa LLC · Jacksonville, FLN750LMSadler Terry A · Sidney, MEN750NHScruton Todd B · Strafford, NHN750PHTobon Alexander J · Daphne, ALN750PWMoore Robert T · West Richland, WAN750TRGardner John · Lenoir City, TNN750TZSparks Timothy J · Jackson, MIN750USDurrel Eby V · Clearville, PAN750WDFalls Justin M · Lincolnton, NCN750WPPershall Daniel D · Buffalo Gap, SDN750WTClark Billy B · Pride, LAN750XZRussell Morgan G · Springfield, ILN750ZXWidincamp Steve · Dahlonega, GAN750ZZKinsella David T · Littlestown, PAN7510GBoh Air Corporation · Jenks, OKN7510XSeifert Ross W · Pelican Rapids, MN
Back to AD 94-05-05 R1