OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,349

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

N86SADureiko Martin J · Miami, FLBuilt 1980 · S/N A1520950N86TDGuimont William P · Lynnwood, WABuilt 1987 · S/N 1599N86WKAmick Michael K · Franklin, TNS/N 1100N87019Bates Paul L · Livermore Falls, MES/N 1032-74N87021Haugen Delos L · Burlington, NDBuilt 1974 · S/N 1033-74N87041Seidl Charles F · Wasilla, AKBuilt 1974 · S/N 1034-74N8714SFisher Timothy S · Tucson, AZBuilt 1987 · S/N 2037N8718VBecker Chris H · Panama City, FLBuilt 1975 · S/N 1101-75N8724VVintage Wings Aircraft LLC · Centerpoint, INBuilt 1975 · S/N 1102-75N872XGulfstream Aerospace Corp · Savannah, GABuilt 1972 · S/N AA1B-0087N8731VSchutze Eric D Trustee · Ojai, CABuilt 1975 · S/N 1103-75N8746VByron Air Service LLC · Snohomish, WAS/N 1110-75N8750VKeller Klaus · Thetford Center, VTBuilt 1975 · S/N 1104-75N8779Krezel Patrick S · Wasilla, AKBuilt 1973 · S/N 926-73N87800May John C · Prosser, WABuilt 1946 · S/N 12-2N87803Davenport David H · Fayetteville, NCBuilt 1946 · S/N 12-4N87834Chase 13 LLC · Wilmington, DES/N 15264N87867Anderson Ryan L · Minneapolis, MNBuilt 1946 · S/N 15485N878ALCathcart Richard Gordon · Covington, VABuilt 2018 · S/N 65-10175N87DMKappel Fred G · Memphis, TNBuilt 1988 · S/N 1533N87LAAdams Kirk · Sanger, CABuilt 1989 · S/N 87N87VKBurgstaller Martine S · DeurneBuilt 1960 · S/N 22-8879N87WRJohnston Donald C · Davis, CABuilt 1967 · S/N 520N88037Willke Sue E · Sewickley, PAS/N 15654N88038Quirk Charles L · Lake Charles, LABuilt 1946 · S/N 15655N88039Chapman Jeffrey C · Brownsburg, INBuilt 1946 · S/N 15656N88047Rjr Airdrome Inc · Dover, DEBuilt 1974 · S/N 1036-74N88079East Hill Flying Club Inc · Ithaca, NYBuilt 1974 · S/N 1038-74N88086Saliba Eric · Mineola, NYBuilt 1974 · S/N 1039-74N8809Velociraptor Aviation LLC · Toney, ALBuilt 1973 · S/N 929-73N88134Morris William F B · Klamath Falls, ORBuilt 1974 · S/N 1040-74N88140Green Flying Machine LLC · Prior Lake, MNBuilt 1974 · S/N 1042-74N88196Speer Jon H · Bryan, OHBuilt 1974 · S/N 1044-74N88225Horst Aviation LLC · New Holland, PABuilt 1946 · S/N 15842N88243Newbegin James T · Mc Alpin, FLBuilt 1974 · S/N 1045-74N88319Skyhunter Aviation LLC · Novi, MIBuilt 1974 · S/N 1052-74N88336Krehbiel Mike A · Gallatin, MOBuilt 1974 · S/N 1056-74N88348Keller Kelly · Fort Worth, TXBuilt 1974 · S/N 1059-74N88361Robinson Anthony James · Miami, FLFirst renewal noticeBuilt 1946 · S/N 15979N88375Edgar Douglas · Mountain View, MOBuilt 1975 · S/N 1100-75N88397Hunt Daniel R · Hayward, CABuilt 1974 · S/N 1061-75N88408Steel Mimi · Caldwell, IDBuilt 1974 · S/N 1062-75N88446Gall Peter D · Morgantown, WVS/N 1064-75N88453Tribfelner Lance J · St Charles, MIBuilt 1974 · S/N 1065-75N88459Carnevale Victor N · Fayetteville, NCBuilt 1974 · S/N 1067-75N8852LFederman Cecilia · Beaumont, CABuilt 1974 · S/N AA1B-0452N88587Tucker Anthony W · Brazoria, TXBuilt 1946 · S/N 16213N8858LRedro Inc · Owatonna, MNBuilt 1974 · S/N AA1B-0358N8860LCrowe George J · East Ridge, TNBuilt 1974 · S/N AA1B-0360N88610Cape May Aerial Advertising LLC · Rio Grande, NJBuilt 1946 · S/N 16238
Back to AD 80-25-02 R2