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.
N2484UFiske James K · North Andover, MAN2485DDraggin Tail Pilots LLC · Prospect, PAN2485HMcnutt Richard K · De Pere, WIN2485JPercival Sheila · Watson, ILN2485KKaplan Samuel · Santa Paula, CAN2485VTrayhan Edward J · Schertz, TXN2485YMcdonald Gregory S · Mena, ARN2486KSolar Joseph R · Punta Gorda, FLN2486VSale Reported · Billings, MTSale reportedN2486YCarfinder LLC · Huntington Station, NYN2487DBlue Four Aviation LLC · North Pole, AKN2487KKing Gary B · Suffolk, VAN2487UBaske Scott E · Hanna, INN2487YBradley Jeff C · Schertz, TXN2488DStokes David R · Sleepy Hollow, ILN2488JMcdonald Nicholas W · Phoenix, AZN2488KBruton Bert L · San Angelo, TXN2488NByrne Mark T · Owensboro, KYN2488USchafer Gerhard Walter · Fairbanks, AKN2488VSpencer Robert J · Florence, AZN2489DClark Joseph F III · New Smyrna Beach, FLN2489JVan Velson Richard Lee · Brule, NEN2489LCalifornia Aviation Services Inc · Riverside, CAN2489UKauachi Melik · Brownsville, TXN248CCRegistered aircraftN248ZLightsey Aviation LLC · Jacksonville, FLN24909Mathis James · Lebanon, PAN2490JSchmitt Rudy · Brookshire, TXN2490LWimberly Thomas F III · Bend, ORN2490NCessna N24909n LLC · Jacksonville, FLN2490UBredbenner Carl A · Dalmatia, PAN2491EAero Applications Inc · Burley, IDN2491LMcgivern James · San Pedro, CAN2491VZweifel Stephan G · Northfield, MNN24929N24929 LLC · Ada, MIN2492JGerke Russell L · Kalispell, MTN2492NAlbert Lea Airport Inc · Albert Lea, MNN24934Carter Benjamin F · Colusa, CAN24936Scopellite Sebastian · Phoenix, AZN2493JBrunson Anthony W · Evans, GAN2493KPydeski Joseph J · Dunedin, FLN2493VAir Enterprises LLC · Dover, DEN2493YBeauchamp Chris L · Anacortes, WAN2494KWilkie David J · Nashua, NHN2495UKoelbl Aviation LLC · Whitesboro, TXN2496LSequeira Michael J · Troy, MON2496UKloker Daniel E · Owasso, OKN2496YSchwab George E · Stillwater, OKN2497NFischer John T · Fort Worth, TXN2497VDarr Nicholas D · Boron, CA
Back to AD 94-05-05 R1