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.

N906BGBrandywine Soaring Association · Hockessin, DEBuilt 1981 · S/N 3604N907BGSoaring Dutchmen Inc · Wynnewood, PABuilt 1981 · S/N 3650N90KGRobards C David · Sparks, NVBuilt 1983 · S/N 101A0099N910BGCleveland Soaring Society Inc · Hartville, OHBuilt 1982 · S/N 3754N91345Hood River Soaring Inc · Hood River, ORBuilt 1978 · S/N 20630N913GMarshall Soaring Club · Marshall, MIBuilt 1982 · S/N 3748N91436Michael Matthew C · Ames, IAS/N 34N917VWLarsen Robert T · Moretown, VTBuilt 2003 · S/N 153N919NDouglas Dutton · Lindsborg, KSBuilt 1971 · S/N 175N91BGAndrews Kenneth S · Clinton Township, MIS/N 5529SN91HHHarris Hill Soaring Corp · Horseheads, NYBuilt 1990 · S/N 21485N91MConner Larry · Los Lunas, NMBuilt 1973 · S/N 17024N921FTMacomber Donald C · Santa Ynez, CAS/N 20514N921GThermalator Soaring Association LLC · Wilmington, DEBuilt 1982 · S/N 3741N923BGFreedoms Wings International Inc · Glenside, PAS/N 34037-K-268N924BGPhiladelphia Glider Council · Hilltown, PAS/N 34038-K-269N925BGRidgetek Inc · Solana Beach, CAS/N 34044-K-275N926BGArizona Soaring Inc · Maricopa, AZBuilt 1986 · S/N 34045-K-276N928BGSailplane Adventures LLC · Santa Barbara, CAS/N 34047-K-278N928VJJamison Douglas M · Eighty Four, PABuilt 1975 · S/N 435N92BGTaylor-Barrett Jane · Tehachapi, CABuilt 1981 · S/N 5530 SN92KGPumphrey Robert L · Greensburg, INBuilt 1983 · S/N 101A097N930BGX-C Soaring Association Inc · Pensacola, FLS/N 34053-K-283N931BGMission Mountain Soaring Society · Ronan, MTS/N 34054-K-284N936BGMid-Atlantic Soaring Association Inc · Frederick, MDS/N 5649CBN93BGNeidert Melvin E · Ulysses, KSBuilt 1981 · S/N 5521 SN940PBSt Louis Soaring Association Inc · Saint Louis, MOBuilt 2018 · S/N 21955N943SBBenson Gene N · Reno, NVBuilt 1970 · S/N 44N945CSGilbreath Michael L · Rochester, WAS/N 101 003N94KGSchibler Gregory W · Encinitas, CABuilt 1983 · S/N 101AP094N955TSTexas Soaring Association Inc · Midlothian, TXBuilt 2006 · S/N 21815N95KGBilyeu Jeffrey E · Reno, NVBuilt 1983 · S/N 101A0095N96128Conner John A Jr · Niceville, FLS/N 20146CN966TSTexas Soaring Association Inc · Midlothian, TXS/N 21820N972AFCivil Air Patrol · Maxwell Afb, ALBuilt 1986 · S/N 21320N975AFCivil Air Patrol · Maxwell Afb, ALBuilt 1984 · S/N 21237N9773Gianforte Joseph D · Canastota, NYBuilt 1971 · S/N 98N9775Gammons Leslie K · Broken Arrow, OKBuilt 1971 · S/N 106N977TSTexas Soaring Association Inc · Midlothian, TXS/N 21821N97GSWillamette Valley Soaring Club · Cornelius, ORBuilt 1977 · S/N 19140N97RDHall John E · Corpus Christi, TXBuilt 1972 · S/N 288GN9814AGreaterboston Soaring Club Inc · Sterling, MABuilt 1978 · S/N 19199N982WTMorse Kathleen A · Groveland, CABuilt 1982 · S/N 19363N98SBVandyke Mark A · Romulus, NYBuilt 1973 · S/N 312N99136Wahl John F · Edgewood, NMS/N 20147CN99167Cascade Soaring Society Inc · East Wenatchee, WABuilt 1976 · S/N 43N991PRoth Thomas E · Vancouver, WAS/N 4-37N99361Kaounas Kostas T · Brookings, SDBuilt 1976 · S/N 1282N995RJNeidert Melvin E · Ulysses, KSBuilt 1975 · S/N 20043N996TAdirondack Soaring Association Inc · Ballston Spa, NYBuilt 1978 · S/N 34130
Back to AD 97-08-06 R1