OpenAirDocs.org
AD 78-20-06

Registered aircraft · 53

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:78-20-06')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:78-20-06')
  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.

N1064GAnding Jay B · Bryan, TXBuilt 1979 · S/N 5007N267SNorth Carolina Soaring Association · Zebulon, NCBuilt 1969 · S/N 1486N3571GMid Continent Aircraft Corp · Hayti, MOBuilt 1964 · S/N 1080N3572GHauser Linda · Ulysses, KSBuilt 1964 · S/N 1081N3573GDuran Robert J · Fort Lupton, COBuilt 1964 · S/N 1082N7212VAir Dakota Flite Inc · Hettinger, NDBuilt 1965 · S/N 1249N7220VRidgway Rick J DBA · Carlisle, INBuilt 1965 · S/N 1257N7229VRiggin Flight Service Inc · Madison, SDBuilt 1966 · S/N 1266N7232VSky Sailing Inc · Warner Springs, CABuilt 1966 · S/N 1269N7234VMorten Jesse L · Larimore, NDBuilt 1966 · S/N 1271N7235VHunter James Rogers · Schertz, TXBuilt 1966 · S/N 1272N7238VKnutson Wayne R · Thompson, NDBuilt 1966 · S/N 1275N7248VAnderson Robert A · Dove Creek, COBuilt 1966 · S/N 1285N7259VKnutson Wayne R · Thompson, NDBuilt 1967 · S/N 1313N7270VAirmotive Service LLC · Brigham City, UTBuilt 1967 · S/N 1320N7271VBurk Casey E · Afton, WYS/N 1321N7282VBrant Owen D · Delta Jct, AKBuilt 1966 · S/N 1295N7290VChristen Aviation LLC · Pawnee City, NEBuilt 1966 · S/N 1299N7603VHauser Linda L · Ulysses, KSBuilt 1967 · S/N 1331N7617VSoaring Utah Inc · Sandy, UTBuilt 1967 · S/N 1345N7629VMountain Air Spray Co · Craig, COBuilt 1967 · S/N 1357N7648VMiller Jerold R · Deering, NDBuilt 1968 · S/N 1376N7649VBoeing Co · Renton, WABuilt 1968 · S/N 1428N7650VNorth Carolina Soaring Association · Zebulon, NCBuilt 1968 · S/N 1378N7669VYpma Gene A · Harrison, MTBuilt 1968 · S/N 1397N7678VHinckley David D · Belton, TXBuilt 1968 · S/N 1406N7696VBoeing Co · Renton, WABuilt 1968 · S/N 1424N7729VNew England Soaring Tug LLC · Perkinsville, VTBuilt 1969 · S/N 1480N7742VNorbury Ross · Boonville, MOBuilt 1969 · S/N 1495N7761VLangley Richard A · Sheyenne, NDBuilt 1969 · S/N 1518N7768VSky Sailing Inc · Warner Springs, CABuilt 1969 · S/N 1525N7772VHauser Linda L · Ulysses, KSBuilt 1969 · S/N 1515N7774VMarshall Soaring Club Inc · Marshall, MIBuilt 1969 · S/N 1528N7783VWarhol Peter J · Peever, SDBuilt 1970 · S/N 1536N7786VZoom Schwartz LLC · Goldthwaite, TXS/N 1539N7799VCb Aerial Application LLC · Kirksville, MOBuilt 1970 · S/N 1552N7967VAnderson Cattle Co Inc · Emporia, KSBuilt 1971 · S/N 1576N7991VNorth Carolina Soaring Association · Zebulon, NCBuilt 1970 · S/N 1586N7998VDonica Leldon H · Marana, AZBuilt 1970 · S/N 1589N8246HLake Elsinore Soaring Club · Wildomar, CABuilt 1965 · S/N 1119N8264HAir Dakota Flite Inc · Hettinger, NDBuilt 1965 · S/N 1137N8272HMorten Jesse L · Larimore, NDBuilt 1965 · S/N 1145N8278HCedar Hill Aviation Service Llpc · Cedar Hill, TNS/N 1147N8279HChilhowee Soaring Association Inc · Benton, TNBuilt 1965 · S/N 1148N8290HSchildberg Gregory · Casey, IABuilt 1965 · S/N 1232N8294HSidney Aviation LLC · Sidney, NEBuilt 1965 · S/N 1163N83786Riggin Flight Service Inc · Madison, SDBuilt 1966 · S/N 1217N8401VGlenn Larry W · Bunn, NCBuilt 1970 · S/N 1601N8403VDonica L H · Marana, AZBuilt 1970 · S/N 1603N8407VDonica Leldon H · Marana, AZBuilt 1971 · S/N 1607
Back to AD 78-20-06