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.

N8170PLock Haven Aircraft Sales · Lock Haven, PABuilt 1963 · S/N 24-3426N8170QMerkes Dennis R · Soldotna, AKBuilt 1952 · S/N 25412N8170TThorn Walter W · Guilford, VTS/N 17556870N8170UFields William B · Climax, NCBuilt 1964 · S/N 17252070N8170XWhittington Melinda Sara Secrest · Columbus, OHBuilt 1961 · S/N 17248670N81714Linenberger Darrell W · Berryton, KSBuilt 1945 · S/N 7AC-333N8171BByker Robert L · Porterville, CABuilt 1957 · S/N 29971N8171LSam Aviation LLC · Long Beach, CAS/N 17256371N8171SLeavitt Adam · Boulder City, NVS/N 15061771N81724Spee James · Redlands, CABuilt 1945 · S/N 7AC-343N8172AWood Thomas A · Salome, AZBuilt 1952 · S/N 25024N8172FButler Donald S · Oak Ridge, NCBuilt 1966 · S/N 15064272N8172UPrice Paul S · Camano Island, WABuilt 1964 · S/N 17252072N8172VStanford Jay J · Kingsland, GAS/N A1500553N8172XVital Twyla J · Seguin, TXBuilt 1961 · S/N 17248672N8173BBetter Air Service LLC · Dailey, WVBuilt 1957 · S/N 29973N8173FJohnson Jacob A · Shawnee, OKS/N 15064273N81742Martin Joseph L · Pike Road, ALBuilt 1946 · S/N 7AC-363N8174BSmith Michael D · King George, VABuilt 1957 · S/N 29974N8174DKerzen Properties LLC · Fayetteville, ARBuilt 1957 · S/N 18-6101N8174FRangefinder Aviation LLC · Fort Collins, COS/N 15064274N8174TMeacham Thomas · Myton, UTBuilt 1960 · S/N 17556874N8174UJenson James H · Downers Grove, ILBuilt 1964 · S/N 17252074N8175AFoster Mike D · Fairbanks, AKBuilt 1952 · S/N 25027N8175BSmith Philip M · Houston, TXBuilt 1957 · S/N 29975N8175DZweifel Douglas L · Anchorage, AKS/N 18-6102N8175SAnderson Marcus D · Memphis, TNBuilt 1965 · S/N 15061775N8175TMachovsky Randolph P · Montague, MIBuilt 1960 · S/N 17556875N8175UN8175u LLC · Rosemount, MNS/N 17252075N8175VTaylor Charles G · Knoxville, TNBuilt 1974 · S/N A1500555N8175XBeebe Shawn D · Ammon, IDBuilt 1961 · S/N 17248675N8176AThom Jacob D · Wasilla, AKS/N 25028N8176DGulf Heavy LLC · Gulf Shores, ALBuilt 1957 · S/N 18-6104N8176LAdams David F · South Lyon, MIBuilt 1967 · S/N 17256376N8176XCorrigan Walter E Jr · Seward, AKBuilt 1961 · S/N 17248676N81775Flying B Aviation LLC · Waynesboro, TNBuilt 1967 · S/N 17255171N8177DBackcountry Flying Experience Inc · Kalispell, MTBuilt 1957 · S/N 18-6105N8177FLong Steven J · Amery, WIBuilt 1966 · S/N 15064277N8177LDenton Scotchie M · Calhoun City, MSS/N 17256377N8177TRegistration Pending · Fairmont, WVRegistration pendingBuilt 1960 · S/N 17556877N8177XUnderground Aviation Group LLC · Elizabethtown, PABuilt 1961 · S/N 17248677N81780Milstein Jakob · Boulder, COBuilt 1945 · S/N 7AC-403N81782Camacho Hector F · Andover, KSBuilt 1945 · S/N 7AC-405N8178LMalone Traci L M · Effingham, ILBuilt 1967 · S/N 17256378N8178TFairbanks Kelly E · Twin Falls, IDBuilt 1960 · S/N 17556878N8178XPaulsen Olaf · Clackamas, ORBuilt 1961 · S/N 17248678N8179BWolford Robert C · Knoxville, TNBuilt 1957 · S/N 29979N8179LExecutive Wings LLC · Bolivar, TNBuilt 1967 · S/N 17256379N8179SOllantair LLC · Chicago, ILBuilt 1965 · S/N 15061779N817DCEverwind Aviation LLC · Kalispell, MTBuilt 1948 · S/N 7DC81
Back to AD 94-05-05 R1