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.
N8170PLock Haven Aircraft Sales · Lock Haven, PAN8170QMerkes Dennis R · Soldotna, AKN8170TThorn Walter W · Guilford, VTN8170UFields William B · Climax, NCN8170XWhittington Melinda Sara Secrest · Columbus, OHN81714Linenberger Darrell W · Berryton, KSN8171BByker Robert L · Porterville, CAN8171LSam Aviation LLC · Long Beach, CAN8171SLeavitt Adam · Boulder City, NVN81724Spee James · Redlands, CAN8172AWood Thomas A · Salome, AZN8172FButler Donald S · Oak Ridge, NCN8172UPrice Paul S · Camano Island, WAN8172VStanford Jay J · Kingsland, GAN8172XVital Twyla J · Seguin, TXN8173BBetter Air Service LLC · Dailey, WVN8173FJohnson Jacob A · Shawnee, OKN81742Martin Joseph L · Pike Road, ALN8174BSmith Michael D · King George, VAN8174DKerzen Properties LLC · Fayetteville, ARN8174FRangefinder Aviation LLC · Fort Collins, CON8174TMeacham Thomas · Myton, UTN8174UJenson James H · Downers Grove, ILN8175AFoster Mike D · Fairbanks, AKN8175BSmith Philip M · Houston, TXN8175DZweifel Douglas L · Anchorage, AKN8175SAnderson Marcus D · Memphis, TNN8175TMachovsky Randolph P · Montague, MIN8175UN8175u LLC · Rosemount, MNN8175VTaylor Charles G · Knoxville, TNN8175XBeebe Shawn D · Ammon, IDN8176AThom Jacob D · Wasilla, AKN8176DGulf Heavy LLC · Gulf Shores, ALN8176LAdams David F · South Lyon, MIN8176XCorrigan Walter E Jr · Seward, AKN81775Flying B Aviation LLC · Waynesboro, TNN8177DBackcountry Flying Experience Inc · Kalispell, MTN8177FLong Steven J · Amery, WIN8177LDenton Scotchie M · Calhoun City, MSN8177TRegistration Pending · Fairmont, WVRegistration pendingN8177XUnderground Aviation Group LLC · Elizabethtown, PAN81780Milstein Jakob · Boulder, CON81782Camacho Hector F · Andover, KSN8178LMalone Traci L M · Effingham, ILN8178TFairbanks Kelly E · Twin Falls, IDN8178XPaulsen Olaf · Clackamas, ORN8179BWolford Robert C · Knoxville, TNN8179LExecutive Wings LLC · Bolivar, TNN8179SOllantair LLC · Chicago, ILN817DCEverwind Aviation LLC · Kalispell, MT
Back to AD 94-05-05 R1