OpenAirDocs.org
AD 97-08-06 R1

Registered aircraft · 607

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-06-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-06-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.

N35WWEichhorn Tyler L · Ramona, CAS/N 20034N361KSBarrett Jane T · Tehachapi, CABuilt 1984 · S/N 21224N363KSBeta Fleet LLC · South Burlington, VTBuilt 1984 · S/N 21228N3698Abair Alan A · Cromwell, INBuilt 1972 · S/N 297GN36WWMahony John P · Ballston Spa, NYBuilt 1976 · S/N 1113N3707Kittleson Allen F · Granbury, TXS/N 13087N374KSAsk Flyers Inc · Hogansville, GABuilt 1983 · S/N 21196N376AZNagel Wanda · Placerville, CABuilt 1976 · S/N 28N37GSElliott Jason · Arlington, TXBuilt 1978 · S/N 20615N37PLTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1978 · S/N 19190N37RBBransford Edward J · Smithfield, VABuilt 1979 · S/N 19295N37WWTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1978 · S/N 3092N37ZSelvidge John K Trustee · Edgewood, NMS/N 4-120N3837MCross Country Soaring Inc · Lonsdale, MNBuilt 1983 · S/N 3764N38KGDebacker Frank A · Highlands Ranch, COBuilt 1984 · S/N 101A0129N3907BCoombes Leroy D · York, SCS/N 15134N393SBTwenty Inc · Wilmington, DEBuilt 1985 · S/N 4-85N3950AChapman John P · Long Beach, CABuilt 1983 · S/N 3793N3950BSky Sailing Inc · Warner Springs, CABuilt 1983 · S/N 5607CBN39810Hoyle Clifford L · Pueblo, COBuilt 1983 · S/N 3813N3981AWalker Carol L · Ennis, TXBuilt 1983 · S/N 5610CBN3981CNorthern California Soaring Association · Byron, CABuilt 1983 · S/N 3807N3981HSt Louis Soaring Association Inc · Saint Louis, MOBuilt 1983 · S/N 3812N3BJFrazin Michael B · Bend, ORBuilt 1972 · S/N 178N3TEShatto Michael L Jr · Klamath Falls, ORS/N 101A0198N3WHNorthern California Soaring Association · Livermore, CABuilt 1973 · S/N 324N3XACentral Ohio Soaring Association · Columbus, OHBuilt 1982 · S/N 252N400BBAiken Geoffrey B · Albuquerque, NMS/N 4-108N400GDBlacklin Peter A · Columbia, MDBuilt 1984 · S/N 4-98N400LSPatterson Robert C · Boulder, COBuilt 1980 · S/N 3446N400MMMississippi State University Soaring Club · Mississippi State, MSBuilt 1985 · S/N 4-127N400YEZidziunas Michael W · Lakeland, FLBuilt 1987 · S/N 4-160N4024Stoltz Charles T · Trenton, MIBuilt 1972 · S/N 206N404ESHardy John A · El Paso, TXBuilt 1969 · S/N 44N406PPLappin Thomas G · Austin, TXS/N 4-128N4101MSandhill Soaring Club Inc · Brighton, MIBuilt 1983 · S/N 3796N4113GLarson David A · Fort Pierce, FLBuilt 1983 · S/N 3794N4115MTucson Soaring Club Inc · Sahuarita, AZBuilt 1983 · S/N 3799KN4116MKennedy Cary A · Toano, VABuilt 1983 · S/N 5608CBN411JRCollegiate Soaring Association Inc · Greeley, COBuilt 1970 · S/N 35N412HSteven Alain P · Lansdale, PABuilt 1979 · S/N 3359N412SLeonard Steven E · Wichita, KSBuilt 1969 · S/N 12012N413MDNyman Robert H · Elsinore, CABuilt 1968 · S/N 28N4173CCompton Francis B · Marfa, TXBuilt 1968 · S/N 33N41KPNorthern California Soaring Association · Byron, CABuilt 1992 · S/N 34176N421EFSoaring Society Of Boulder · Boulder, COBuilt 2013 · S/N 21905N421GBGreater Boston Soaring Club Inc · Sterling, MABuilt 2016 · S/N 21937N421SLBarrett Jane T · Tehachapi, CABuilt 2006 · S/N 21808N4222WTampa Bay Soaring Society Inc · Zephyrhills, FLBuilt 1983 · S/N 3804N422BGWindy City Soaring Association · Hinckley, ILBuilt 1982 · S/N 3711
Back to AD 97-08-06 R1