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.
N4318CEakins Clifford P · Bloomfield, IAN4318LPhillips Matthew L · Las Cruces, NMN4318UCragg Gordon · Georgetown, TXN4319BClay Charles E · Alhambra, CAN431DKrause Derris O · Cumberland, MDN4321CWeiss Elliott · Fresno, TXN4321UBurdett Michael R · Dawsonville, GAN4322CSparrowhawk Aviation LLC · Moraine, OHN4322LShastri Milind J · Seminole, FLN4323LReed Darran K · Whitney, TXN4324CCornfield Cruisers LLC · Urbandale, IAN4324LMesa Aviation LLC · Alpine, TXN4324UPerot Mark E · Homer, LAN4325LJ & F Aviation Adventure LLC · North Fort Myers, FLN43261Haley Billie Jo · San Martin, CAN43264Engebretson Eric T · Medford, ORN4326BRopp Doug · Albany, ORN4327UHodges Caleb F · Omaha, TXN4328CWelch Thomas R · Modesto, CAN43292Brooks Douglas L · Stewartstown, NHN4329LHanson Randy J · North Branch, MNN4329UCarvalho Brandon A · Camarillo, CAN432DTrollinger Lari D · Wanette, OKN4330UPalmer Dana G · Gatesville, TXN4331LOppegaard Craig E · Saint Louis Park, MNN4332HMcchesney Corey D · New Berlin, WIN43339Gregory Raymond P · Waconia, MNN4333EWatters Robert K · Dwight, ILN4333LDover Amanda · Littleton, NCN4334CEyring Joshua S · Diamond, OHN4334UTusko Air LLC · Choctaw, OKN4335LClifford Gary G · Titusville, FLN4335UHarrison Wesley V · Kemah, TXN4336BAlthens Levi W · Wasilla, AKN4336CRegistration Pending · Billings, MTRegistration pendingN4336LWiff Robert A · Tahuya, WAN4337CSpence Stephen L · N Richland Hills, TXN4337LWirt James · Goldsby, OKN4337UStroope Jerry S · Pearland, TXN4338LInsco Kay · Martin, TNN4339BCurrie Andrew C · Oscoda, MIN4339CMurray Erwin L Jr DBA · Emporium, PAN433APetty Clifford C · Cedar Hill, TXN433DLBlue Sky Transport LLC · Deland, FLN433HKuhn Darrell G · Irma, WIN4340BMuehl John M · Maryland, NYN4340CAndersen Andy · Sutton, AKN4340UBenford Kenneth R · Haleyville, ALN4341CHofer Perry L · Doland, SDN4341EJeffryes Richard B · Creswell, OR
Back to AD 94-05-05 R1