OpenAirDocs.org
AD 97-01-01 R1

Registered aircraft · 6,916

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

N8780PChampion Milton · Reno, NVBuilt 1965 · S/N 24-4232N8780YRegistered aircraftBuilt 1969 · S/N 30-1936N8781CNationwide Aviation LLC · Hudson Oaks, TXS/N 34-7670154N8781PJenkins Aviation Ventures LLC · Woodstock, GABuilt 1965 · S/N 24-4233N8783YOsprey Holding Company LLC · Foley, ALBuilt 1969 · S/N 30-1940N8784PCrane Steven · Phoenix, AZBuilt 1965 · S/N 24-4237N8784YFoster Darryl L · The Woodlands, TXBuilt 1969 · S/N 30-1942N8785FBeving Charles J · Garden City, SDBuilt 1976 · S/N 32R-7780116N8786PSisk Jerald L · Brighton, COBuilt 1965 · S/N 26-135N87878International Air Services Inc Trustee · Carson City, NVBuilt 1959 · S/N 24-469N8787PA B Helton Enterprises LLC · Warthen, GABuilt 1965 · S/N 24-4239N8788CSaflight Pilot Training Inc · Manchester, NHS/N 28R-7635182N8788YAerotransit Inc · Milwaukee, WIS/N 30-1946N8789PCannell John D · New Franken, WIBuilt 1965 · S/N 24-4241N878SSMcdaniel Mark · Martinsville, INBuilt 1978 · S/N 34-7870413N8790EFenty Brandon · Normandy, TNBuilt 1976 · S/N 28R-7635214N8790PBison Reserved LLC · Chicago, ILBuilt 1965 · S/N 24-4243N8791YGeboy Alan R III · Baxley, GABuilt 1969 · S/N 30-1949N8792EMann Joshua A · Montgomery, TXBuilt 1976 · S/N 32R-7680178N8792PPrivette Richard E · Oak Hill, FLBuilt 1965 · S/N 24-4245N8793PFlaagan Kevin D · Beulah, NDBuilt 1965 · S/N 24-4246N8794PDelaware Mark P · Phoenix, AZBuilt 1965 · S/N 24-4247N8795PJejgr LLC · Presho, SDBuilt 1965 · S/N 24-4248N8795YJohnson Paul · Wichita Falls, TXS/N 30-1954N8796PAllie Doug B · Glasgow, MTBuilt 1965 · S/N 24-4249N8797PPlant Curtis W · Runge, TXBuilt 1965 · S/N 24-4250N8797YHight Derrick R · North Aurora, ILBuilt 1969 · S/N 30-1812N8798EFuller Glenn C · Santa Paula, CAS/N 28R-7635215N8799PMontgomery M Kim · Vega, TXBuilt 1965 · S/N 24-4252N87CWZou Christian · Chandler, AZBuilt 1967 · S/N 30-1639N87JTN87jt Inc · Lewes, DEBuilt 1977 · S/N 34-7770274N87KGCherokee From Sebring LLC · North Brunswick, NJBuilt 1969 · S/N 28R-35043N87MBTraining Planes LLC · Tampa, FLBuilt 1972 · S/N 34-7250070N87RPWhitehead Glenn K · Friendswood, TXS/N 24-1603N8800PAnp Networks Corp · Las Vegas, NVS/N 24-4253N8800YAlexander City Aviation Corp · Alexander City, ALBuilt 1969 · S/N 30-1956N8802PPennington Mitchell T · Medley, WVBuilt 1965 · S/N 24-4257N8803PWade Brian K · Apalachin, NYBuilt 1965 · S/N 24-4258N8804YMartino Aviation LLC · Wilmington, DES/N 30-1960N8806PZiolkowski James E · Amarillo, TXBuilt 1965 · S/N 24-4261N8807PRegistered aircraftBuilt 1965 · S/N 24-4263N8807YRich Lucas Aircraft Sales LLC · Lincoln Park, NJBuilt 1969 · S/N 30-1964N8808YAukes Brian E · Huxley, IABuilt 1969 · S/N 30-1965N8809PPa24 LLC · Painesville, OHBuilt 1965 · S/N 24-4265N8811YHutchinson Douglas E · Cle Elum, WABuilt 1969 · S/N 30-1968N8812PRegistered aircraftBuilt 1965 · S/N 24-4267N8812YSpain Air LLC · Dadeville, ALBuilt 1969 · S/N 30-1969N8813CUlrich Helmut Wiegand · Satellite Beach, FLBuilt 1976 · S/N 32R-7680140N8813PWolcott Kent E · Colorado Springs, COBuilt 1965 · S/N 24-4268N8814CGharazeddine Raja N · Kaplan, LABuilt 1976 · S/N 34-7670155
Back to AD 97-01-01 R1