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.
N38070Aas LLC · Ovid, MIN3808KBartholomew Donald B · Gardnerville, NVN3808LGreensburg Jeanette Airport Administration · Jeannette, PAN3809LSale Reported · Oak Harbor, WASale reportedN3809RImhof Donald R · Central City, NEN3809SPhillippi Victor L · Broadus, MTN380JBBarron Stony J · Spearsville, LAN380LAPounders Brent · Prosper, TXN380RGibbs Clifford E · Saint Clair, MIN380TSale Reported · West Sacramento, CASale reported, pending cancellationN3810KFiser Richard L · Palmer Lake, CON3810SGrant Sidney Tucker · La Porte, TXN3811JWright Wayne M DBA · Chestertown, MDN3811SFuist Richard A · Lake City, FLN3811VFlying Asian Aviation Inc · Richmond, CANon-citizen corporation, flight hours not reportedN3812LAune Todd A · Harlingen, TXN3813JWinnie Daniel R · Seattle, WAN3813LBuyak David W · New Hartford, CTN3813SHughes Todd R · Rocky Ford, CON3813VTailwheelin LLC · Richland, WAN3814SRegistered aircraftN3815LCordova Tomy · Hastings, MIN3815SRickard Hudson · Cleveland, OHN3815VKovac James M · Muskego, WIN3816JJames Randy C · Knob Noster, MON3816VStevens Scott D · Corsicana, TXN3817KMax Cl Inc · Wilmington, DEN3817SLake Kris E · Wasilla, AKN3818JAyresouth Aviation Inc · Lithia Springs, GAN3818RRuddle Aviation LLC · Lawrenceburg, TNN3819LRay Aviation LLC · Burkett, TXN3819RMeznarsic Victor F · Alton, ILN3820KRutter Clarence W III · Norman, OKN3820SSchrader Jerome · Rocklin, CAN3820VShalom Aviation LLC · Miami, FLN3821HWilson Christopher W · Honey Grove, TXN3821LSky Bryce Flying Club LLC · Basye, VAN3823KHarris Kenneth L · Greeley, CON3823RElectra-Vision Advertising Corp · Claremont, CAN3823VTollefson Jason C · Zillah, WAN38244Munroe Consulting Inc · Ocala, FLN3824JBalcsik Christopher A · Tehachapi, CAN3824KJones James Milton · Madison, GAN3824LNewhart Manfred A · Boulder, CON3824SPhelps Aero Co LLC · Salem, ORN3825RHoogstra Jay D · Sheboygan Falls, WIN3826SLamal Thomas K · Fairbanks, AKN38272Wright Attitudes Inc · Taft, TNN3827JCollins Camden B · Millersport, OHFirst renewal noticeN3827KRaibley David M · Redding, CA
Back to AD 94-05-05 R1