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.

N7140KChandelle Ltd · Brighton, COBuilt 1950 · S/N 18-358N7142KHogan Mark C · Bend, ORBuilt 1950 · S/N 18-360N7148KNormark Ronald L · Weirsdale, FLBuilt 1950 · S/N 18-367N7149KMichel Daniel T · Sterling, AKBuilt 1950 · S/N 18-369N714SStoeppler Heidi Lynae · Sioux Falls, SDBuilt 1994 · S/N 682N714TAPaterson Fraser · Torrance, CABuilt 1977 · S/N 15279410N714TJTop 5 Media LLC · Santa Maria, CABuilt 1977 · S/N 15279417N714TRStocks Kristian · Billings, MTBuilt 1977 · S/N 15279424N714TUDamschroder Rex A · Fremont, OHBuilt 1977 · S/N 15279427N714UCStroud James DBA · Union, SCBuilt 1977 · S/N 15279435N714UDThunderfighter LLC · Englewood, COBuilt 1977 · S/N 15279436N714UFBoraam Aviation Inc · Prospect Heights, ILBuilt 1977 · S/N 15279438N714VGJust Tailwheels LLC · Sarasota, FLBuilt 1977 · S/N 15279462N714VHJet & Rotor Aviation LLC · Sacramento, CAS/N 15279463N714VLOdonata LLC · Lewiston, IDBuilt 1977 · S/N 15279466N714VNFolstad Bennett O · Sidney, MTBuilt 1977 · S/N 15279468N714VYTappan East LLC · New Philadelphia, OHBuilt 1977 · S/N 15279478N714VZSojka Brian Z · Herndon, VABuilt 1977 · S/N 15279479N714WDDaviation Inc · Willoughby, OHBuilt 1977 · S/N 15279482N714WECirrus Inc · Wilmington, DEFirst renewal noticeBuilt 1977 · S/N 15279483N714WGWhitt Sana F · East Quogue, NYS/N 15279485N714WPWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279492N714WSR & D Aircraft Inc · Jamestown, NCBuilt 1977 · S/N 15279495N714WTJones Freda C · San Antonio, TXBuilt 1977 · S/N 15279496N714WWVess Gerald · Livingston, TXS/N 15279499N714XBWings Over Texas Holdings LLC · Denton, TXBuilt 1977 · S/N 15279504N714XJSummit Aviation Holdings Of Nwa Inc · Rogers, ARBuilt 1977 · S/N 15279511N714XXHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1977 · S/N 15279524N714YKThurman Glen · Mineola, TXBuilt 1977 · S/N 15279536N714YWHiflite LLC · Athens, ALBuilt 1977 · S/N 15279547N714YXLone Star Aero Inc · Fort Worth, TXBuilt 1977 · S/N 15279548N714ZBRegistered aircraftBuilt 1977 · S/N 15279552N714ZCMauser William T · Rio Linda, CABuilt 1977 · S/N 15279553N714ZGNotam Aviation LLC · Portage Des Sioux, MOBuilt 1977 · S/N 15279557N714ZPDippold Lois M · Perry, MIBuilt 1977 · S/N 15279564N714ZUJet & Rotor Aviation LLC · Sacramento, CABuilt 1977 · S/N 15279569N714ZXWagner Michael · Winter, WIBuilt 1977 · S/N 15279572N714ZYCoco Aircraft Inc · Merritt Island, FLBuilt 1978 · S/N 15282152N7152KWheeler Donald C · Eureka, CABuilt 1950 · S/N 18-373N7153KTallgrass Aviation LLC · Sharon Springs, KSBuilt 1950 · S/N 18-372N7154KSwanson Gc · Valentine, NES/N 18-374N7155KSheffels L And Son · Wilbur, WABuilt 1950 · S/N 18-375N7156KAttwood Nona M · Fairbanks, AKS/N 18-377N7158KDoody James P · South Glens Falls, NYBuilt 1950 · S/N 18-378N715TLucy Roy · Ada, OKFirst renewal noticeBuilt 1977 · S/N 15279611N71625Harris Scott · Oregon City, ORBuilt 1946 · S/N 3052N7164KSwanson Thomas J · Pukwana, SDBuilt 1950 · S/N 18-382N7168KDotzenroth David A · Watertown, MNBuilt 1950 · S/N 18-388N7172KMeader Derek S · Marfa, TXBuilt 1950 · S/N 18-396N7175LDelong Aviation Services LLC · Murray, UTBuilt 1974 · S/N AA1B-0455
Back to AD 80-25-02 R2