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.

N68816Mirkovic Alex · Friendswood, TXBuilt 1978 · S/N 15282391N6883KDrb Helicopters LLC · Klamath Falls, ORS/N 16-726N6884KWyatt Mary Ellen Personal Representative · Weirsdale, FLBuilt 1949 · S/N 16-728N688CMIcan Solutions LLC · Fargo, NDS/N 15282421N68920Richmor Aviation Inc · Hudson, NYBuilt 1978 · S/N 15282403N68926Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282405N68931Denman Diana L · Plain, WIBuilt 1943 · S/N 5-1436N68934Bapes Debra L · Powell, OHS/N 15285341N68938Wingspan 152 LLC · Valparaiso, INBuilt 1978 · S/N 15282408N68954Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282414N68956Spartan Education LLC · Tulsa, OKFirst renewal noticeBuilt 1978 · S/N 15282415N68961Shouling & Philip Enterprise · Lancaster, CABuilt 1978 · S/N 15282416N68963University Of Michigan Flyers Inc · Ann Arbor, MIBuilt 1978 · S/N 15282417N68ACSchgallis Richard J · Gainesville, VABuilt 1977 · S/N 15280781N68KFDelconte Anthony T · Old Hickory, TNBuilt 2012 · S/N S9505-0122N68MEPeigneux Brothers Llp · Malta, MTBuilt 1968 · S/N 625N6900Adams Paul T · Pompano Beach, FLBuilt 2023 · S/N 17-AN69009Jwa Flight School LLC · Bolingbrook, ILBuilt 1978 · S/N 15282429N69011Sunrise Aviation Inc · Ormond Beach, FLBuilt 1978 · S/N 15282431N69012Chapel Hill Flying Club Incdba · Sanford, NCBuilt 1978 · S/N 15282432N69016Hillsboro Aero Academy LLC · Hillsboro, ORBuilt 1978 · S/N 15282435N69019Lange Walter · Plymouth, MABuilt 1978 · S/N 15282438N69023Gilbert Jeffrey R · Dahlonega, GABuilt 1978 · S/N 15282441N69031Lewis Garry L · Livingston, LABuilt 1978 · S/N 15282448N69036Long Robert D · Kinston, NCBuilt 1978 · S/N 15282451N69042Poplar Grove Airmotive Inc · Poplar Grove, ILBuilt 1978 · S/N 15282455N69043Davidson Craig H · Heber City, UTBuilt 1978 · S/N 15282456N69045Eburg Aero LLC · Ellensburg, WABuilt 1978 · S/N 15282457N69047Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282459N69053Aerofeather Aviation Inc · Suffolk, VABuilt 1978 · S/N 15282463N69066Lake Elmo Aero LLC · Lake Elmo, MNBuilt 1978 · S/N 15282470N69078Central Texas College · Killeen, TXBuilt 1981 · S/N 15285345N69104Giger Janice F · Weston, ORBuilt 1978 · S/N 15282484N69110Zumbrun Dennis · Montz, LABuilt 1978 · S/N 15282488N69121Everett Rylan C · Broken Bow, NES/N 15282496N69125Pine Hill Holdings LLC · Richmond, VABuilt 1978 · S/N 15282500N6913Cooper Steven J · Redwood City, CABuilt 1949 · S/N 16-642N69149Joyner Carol M · Claremont, CABuilt 1978 · S/N 15282514N69156Lehman Alexander D · Sanford, NCBuilt 1978 · S/N 15282518N69173Brs Leasing Inc · Wilmington, DEBuilt 1981 · S/N 15285346N69187Green Airports Development Corp · Kemah, TXBuilt 1981 · S/N 15285347N69189Lehman David G · Kent, WABuilt 1978 · S/N 15282539N691JCFlabob Airport LLC · Jurupa Valley, CABuilt 1978 · S/N VAC-117-78N69200Propel Air LLC · Pottstown, PABuilt 1978 · S/N 15282548N69204Fca Flight Center Inc · Fitchburg, MABuilt 1978 · S/N 15282552N69205Oklahoma State University · Stillwater, OKBuilt 1978 · S/N 15282553N69207Horman Richard Scott · Las Vegas, NVBuilt 1978 · S/N 15282555N69212Briner Micah E · Martinsville, INBuilt 1978 · S/N 15282560N69213Weedhopper Aviation LLC · Sparks, NVBuilt 1978 · S/N 15282561N69228Wings Over Texas Holdings LLC · Denton, TXBuilt 1978 · S/N 15282573
Back to AD 80-25-02 R2