OpenAirDocs.org
AD 94-20-04 R2

Registered aircraft · 4,469

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-20-04-R2')
    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-20-04-R2')
  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.

N406TLevel Wings LLC · Jefferson City, MOBuilt 1966 · S/N D-8240N406WCCebulski Wade E · Seeley Lake, MTBuilt 1964 · S/N D-7723N4077AFarmer Gary E · Saint Augustine, FLBuilt 1970 · S/N D-9109N4080SCosse John J Jr Trustee · Lenexa, KSBuilt 1975 · S/N D-9728N4083A4083a LLC · Wilmington, DES/N D-9110N4084CKrech Gordon L · Rolla, NDBuilt 1979 · S/N D-10184N4084SDavenport Michael · Naperville, ILBuilt 1975 · S/N D-9729N4086APippert James R · Dysart, IABuilt 1970 · S/N D-9112N4086S80'S Associates Inc · Pittstown, NJBuilt 1975 · S/N D-9731N4089SRaii3 LLC · Lewes, DEBuilt 1975 · S/N D-9732N409MFenton Richard O · Weatherford, TXBuilt 1969 · S/N D-8981N409RCrawford Russell W · Hurricane, UTS/N D-6011N409SSBlackwell Aviation Inc · Bell Vernon, PABuilt 1965 · S/N D-7952N40GHagerty Environmental LLC · Kennett Square, PABuilt 1972 · S/N D-9342N40GMSteven E Cox · Bend, ORBuilt 1964 · S/N D-7343N40KTDemuth Gabriel J · Jackson Springs, NCBuilt 1968 · S/N D-8717N40NLVetter Brent E · Helena, MTBuilt 1958 · S/N D-5743N4107SAnnamar LLC · Wilmington, DEBuilt 1975 · S/N D-9735N411EGCompton William C · Anchorage, AKBuilt 1966 · S/N D-8184N4127SKrall Jeff P · Mitchell, SDBuilt 1975 · S/N D-9738N412YMurrieta Humberto · San Antonio, TXS/N D-9292N4135SRazzyfish Inc · Colton, CABuilt 1975 · S/N D-9787N413EEReyenga Steven G · Shreveport, LABuilt 1962 · S/N D-6999N413GKKgc Holdings Ltd · Newark, TXBuilt 1973 · S/N D-9450N413KJHuber Jeffrey C · Sidney, OHBuilt 1980 · S/N D-10307N4143SFrederickson Mark T · Cameron Park, CABuilt 1975 · S/N D-9743N4149SDelgado Dimitri Antonio · Tampa, FLBuilt 1975 · S/N D-9745N4151SMidland Avionics LLC · Louisville, KYS/N D-9746N4154SWilanco Inc · Berkeley, CABuilt 1975 · S/N D-9751N415DHSparks Group Inc · Jay, OKBuilt 1957 · S/N D-4916N4163ASalida Aviation Partnership Group · Moffat, COBuilt 1970 · S/N D-9121N4164SFabien Turpaud Corp · Lewes, DEBuilt 1975 · S/N D-9753N416GFHahn Steven P · Hutchinson, MNBuilt 1964 · S/N D-7497N4175SBauman Loren A · Lewisville, NCS/N D-9756N4177SMiles Insurance Inc · Inverness, ILBuilt 1975 · S/N D-9757N417BCBain Eric Josh · Quinlan, TXBuilt 1956 · S/N D-4792N4180SPalomino Princess Express LLC · Helena, MTS/N D-9755N4187SJ&S Aviation Services LLC · Hastings, NES/N D-9765N4192ARocky Mountain Aviation Inc · Wilmington, DEBuilt 1970 · S/N D-9128N4192SStecklein Aviation LLC · Colleyville, TXBuilt 1975 · S/N D-9766N4197SIndependence Aviation Inc · Scottsdale, AZBuilt 1975 · S/N D-9762N41CMClark Patrick L · Kenai, AKBuilt 1977 · S/N D-9967N41SBBrillaud Stephen A DBA · Germantown, TNBuilt 1964 · S/N D-7608N41TWFair James A · Derby, CTBuilt 1961 · S/N D-6563N41XEMedic Choppers LLC · Springdale, ARS/N D-2871N4200DHarding Jeromy · Port Richey, FLBuilt 1955 · S/N D-4408N4201DPhilpott Stuart · Taylorsville, KYBuilt 1955 · S/N D-4398N4208DWiley Robert S · Fayetteville, TNBuilt 1955 · S/N D-4411N4210DKeefer C Paul · Venus, TXS/N D-4415N4211BAdair Edward A · Hemet, CAS/N D-4222
Back to AD 94-20-04 R2