OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,350

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.

N112TGTalbot Skip · Springfield, ILS/N 112N112THHanson David J · Elgin, TXS/N 15280204N1134Limbach John R · Morris, ILBuilt 1968 · S/N 6703N113ATBanister Randall D · Las Animas, COBuilt 1978 · S/N 38-79A0286N113EZKing Larry L · Libby, MTBuilt 1985 · S/N 1069N113FASale Reported · Dallas, TXSale reported, canceledBuilt 1981 · S/N 15285090N113PATundra Aviation Inc · Casselton, NDBuilt 1948 · S/N 14-113N1143ENevarrow Leon · Spring Valley, CABuilt 1977 · S/N 1215-77N114JKKrueger Grant M · Fort Bragg, CAS/N 2006-1N114TAviation Training Solutions LLC · Hilo, HIBuilt 1952 · S/N 18-2228N115CFFlying C Leasing · Wilmington, DES/N 15283557N115SCMohamed Eman Z · Lubbock, TXBuilt 1946 · S/N 11 BC 602N115SSSoutheastern Oklahoma State University · Durant, OKBuilt 1979 · S/N 15283679N11642Alexander Andrew B · Anchorage, AKBuilt 1972 · S/N 836-72N1164DStreng Martin K · Carson City, NVBuilt 1972 · S/N 837-72N1165ETruman Sparks Aviation LLC · Wink, TXBuilt 1977 · S/N 1216-77N11663Parisi Keith P · Wallkill, NYBuilt 1972 · S/N 842-72N11664Mosher Jacob D · Nevada, MOBuilt 1972 · S/N 843-72N11667Winiarski Kenneth J · Forest Twp, MEBuilt 1972 · S/N 845-72N11670Michaud Paul K · Forest Lake, MNBuilt 1972 · S/N 846-72N11672Mooney Services LLC · Greenbush, MNS/N 848-72N11675Nilles Paul · Athens, OHBuilt 1972 · S/N 850-72N11683Osborne Barry G · Brainerd, MNBuilt 1972 · S/N 852-72N11695Rvi Aviation LLC · Clay Center, KSBuilt 1972 · S/N 856-72N116ATTrevisan Hugo S · Polk City, FLS/N 38-78A0731N116BHBighorn Airways Inc · Sheridan, WYBuilt 1963 · S/N 18-8041N116PWRm Construction LLC · Greeley, COS/N 116N116TRobinett Barton L · Frankston, TXBuilt 1952 · S/N 18-2230N11704Jackman William L · Newman Lake, WAS/N 857-72N11709Hutchins Reid C · Hanover, NHBuilt 1972 · S/N 859-72N1170YMacmullen Kenneth P · Quakertown, PAS/N 15059570N11720Mcfarlane Kevin E · Dubuque, IABuilt 1972 · S/N 860-72N1174EInman James Dylan · Parsons, TNS/N 1228-78N1177GFuellner Seanl · Shelocta, PAS/N C.P.M.-2N1179EPlane Air LLC · Paducah, KYBuilt 1977 · S/N 1220-77N117ATHill George R · Calhoun Falls, SCBuilt 1978 · S/N 38-78A0631N117CDSteincamp Erwin · Denison, TXBuilt 1998 · S/N CD001N117TLOver-Head Productions Inc · Wilmington, DES/N 18-2231N117TNNichols Timothy P · Reno, NVBuilt 1976 · S/N AA1B0637N1184EHutchins Chad M · Colorado Springs, COBuilt 1977 · S/N 1217-77N11854Wildenberg Craig E · Menomonie, WIBuilt 1972 · S/N 825-72N11861Haga Kim E · Karlsruhe, NDS/N 829-72N11911Hostler James A · Eastsound, WABuilt 1974 · S/N DSA3N119ATH E P Aviation LLC · Logansport, INBuilt 1978 · S/N 38-78A0421N119PBBarrett Patrick E · Poulsbo, WABuilt 1989 · S/N 89-01N119RCompton Danny M · Kent, OHBuilt 1978 · S/N AA1C0132N11BAMccloskey Michael R · Saint Paul, MNBuilt 1978 · S/N 38-78A0317N11CYOdonnell Justin M · Amelia, OHS/N AA1C-0011N11FULow Country Soaring Association · Ridgeland, SCS/N 25-7556221N11NLGould Leland E · Kirkland, WABuilt 1989 · S/N 1108
Back to AD 80-25-02 R2