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.
N3582SMcmath Albert J Jr · Onley, VAN3582TSmith Frank · Tulsa, OKN3582ZVan Winkle Randy M · Van Buren, MON3583JVali Air Service LLC · Livingston, MTN3583SWalls Jerry L · Hawley, TXN3583TTurner David R · Anchorage, AKN3583VTodd Brian J · North Ridgeville, OHN3584CSnyder Kathryn J · Sutherland, NEN3584LKlesser Zachary S · Coronado, CAN3584SPaul Aviation LLC · Wasco, CAN3584VMurdoch Bryan · Lantana, FLN3585CRachels Paul R · Tacna, AZN3585KLohse Dennis A · Stevensville, MTN3585SNorman Jon D · Plainwell, MIN3586TEdwards James W · Del Norte, CON35878Cape May Aerial Advertising LLC · Rio Grande, NJN3587HIlatina LLC · Carson City, NVN3587JJacobson Austin G · Los Alamos, NMN3587SRegistered aircraftAssigned, pending cancellationN3587TManning Michael W · Chanhassen, MNN3588LVandegrift David H · St Paul, MNN3589CPalmer Frederick W · Huntington Beach, CAN3589LSale Reported · Bloomburg, TXSale reportedN3589SErickson Miles · Langley, WAN3589TChristensen Rande L · Cambridge, MNN3589ZHart Gregory R · Eden Prairie, MNN358KSForgues Inc · Wilmington, DEN358TACrow Edward N · Silverdale, WAN3590CZwingmann Ken · Whittier, CAN3590JLutes Robert Trustee · New Paris, INN3590SNorthwest Aircraft Services LLC · Hayden, IDN3591CSchlender Michael E · Clintonville, WIN3591SPitt Kenneth · Paonia, CON3591TRussell William E · Remus, MIN3591VVeteran Aviation Services LLC · Frederick, MDN3591ZFoss Rick · Lemmon, SDN35927Fielding David J · Scarborough, MEN3592TMcnaney David L · Hysham, MTN3593EPusser Joshua D · Coats, NCN3593HYanks Air Museum · Baldwin Park, CAN3593KThiessen Elvin D · Butterfield, MNN3594CNichols Jamie · Naples, MEN3594ZJuhan Crawford F Jr · Crawford, GAN35959Southern Aircraft Consultancy Inc Trustee · Casper, WYN3595JSchroeder Glenda P · Evansville, INN3595SBarnett Carl Chris · Todd, PAN3595VRose James S · New Port Richey, FLN3596JOld Trail Inc · Baker City, ORN3596VPetko James G · Mishawaka, INN3597SHawkins Ronald Lee · Vancouver, WA
Back to AD 94-05-05 R1