OpenAirDocs.org
AD 97-08-02 R1

Registered aircraft · 45

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:97-08-02-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:97-08-02-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.

N105GDHudson Mitchell C · Erie, COS/N 10N107JWPlayer Jennifer L · Stevenson, WAS/N 428N117TBSaunders Christopher D · Lehighton, PAS/N 17N130JBBenson Arthur V · Brunswick, GABuilt 1986 · S/N 74N13SGBay Area Soaring Associates Inc · San Jose, CABuilt 1985 · S/N 69N144TCypress Soaring Inc · Hemet, CABuilt 1989 · S/N 266N14MGBuker Terrance · Burnsville, NCS/N 62N14SZWoenker Timothy E · Columbia City, INS/N 96N14ZZKlunk Lewis J · Cambridge, MABuilt 1987 · S/N 176N16DEWashington Robert D · Eureka, MOBuilt 1984 · S/N 6N16JJEggert Darrell R · San Luis Obispo, CABuilt 1986 · S/N 97N18MGThomas Nicholas J · Incline Village, NVBuilt 1985 · S/N 4N19BEVan De Velde Thomas E · Brookline, MAS/N 27N224BDuncan Terry Trustee · Cupertino, CABuilt 1987 · S/N 205N224DWReid Michael · Denver, COS/N 62N244CXIto Rysuke · Everett, WAS/N 83N26HLEngel Carl J · Campbell, CAS/N 31N27SGMcmaster Justin Thomas Jr · Horseheads, NYBuilt 1992 · S/N 419N301YCHenson Van E · Livermore, CABuilt 1978 · S/N 88N32086Hinniger Werner M · HamburgBuilt 1985 · S/N 65N33DXBostik Josef J · Green Cove Springs, FLBuilt 1985 · S/N 33N380SMazure Morris Jay · Gardnerville, NVBuilt 1978 · S/N 67N3DDTirca Laviniu H · Philadelphia, PABuilt 1986 · S/N 145N400HBKautter William J · Columbia, MDBuilt 1995 · S/N 550N43SGNoordergraaf Alexander A · Concord, NHBuilt 1986 · S/N 82N44BXBoedecker Paul L · Excelsior, MNBuilt 1986 · S/N 58N4989CBernatz Gerald F · Saint Louis, MOBuilt 1978 · S/N 79N505KAFairbairn Jacob Andrew · Fort Worth, TXS/N 50N526BCPortman Lance N · Morgan Hill, CABuilt 1988 · S/N 244N54HWUS Junior Soaring Association · Brighton, MIBuilt 1986 · S/N 113N560RProkes William J · Tempe, AZBuilt 1987 · S/N 147N578JVMaag Andrew J · Austin, TXBuilt 1988 · S/N 233N57PPStewart Michael · Park City, UTS/N 313N65JJJackson James A · Houston, TXBuilt 1993 · S/N 472N67WSHopke Kurt Ervin · Escondido, CAS/N 8N6XDButler Julie L · Los Osos, CABuilt 1987 · S/N 202N717MJPhiladelphia Glider Counsil Inc · Hilltown, PAS/N 211N71TTRobert Christian Daniel · Ogden, UTBuilt 1977 · S/N 136N77AUCoder Don Erdman · Arlington, TXS/N 77N7958CLeonard Ronald A · Peculiar, MOS/N 251N84DFMollified LLC · Beaver, PABuilt 1986 · S/N 128N87BDHarrison Lee · Rensselaer, NYS/N 78N888TKCloclasure David L · Bringhurst, INBuilt 1986 · S/N 134N941KSCrippen Terrence M · Maple Valley, WABuilt 1985 · S/N 13N97DGLoeffler Herbert M Jr · Saratoga Springs, NYBuilt 1986 · S/N 108
Back to AD 97-08-02 R1