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.

N5019ZCsapos Garry A · Ovid, MIS/N 22-8634N501ELJourneys Aviation Inc · Boulder, COBuilt 2009 · S/N 1404-2009N5021ZFansler Rick L · Delta, OHBuilt 1961 · S/N 22-8636N5023ZBauer Glenn D · Wishram, WABuilt 1961 · S/N 22-8638N5025MRezich Nicholas R · Green Bay, WIBuilt 1978 · S/N 1274-78N5025UDuke Michael R · Mc Gregor, TXBuilt 1978 · S/N 1275-78N5025ZDean Charles William III · Boyle, MSBuilt 1961 · S/N 22-8640N50264Hooper Kenneth R · Hermitage, TNBuilt 1979 · S/N 1328-79N5026FRegistration Pending · Greenville, NCRegistration pendingBuilt 1978 · S/N 1276-78N5026KGriswold David M · Port Townsend, WABuilt 1978 · S/N 1278-78N5026SSchwenker Jerry D · Maquoketa, IAFirst renewal noticeBuilt 1979 · S/N 1326-79N5026ZBrown Robert C III · Whiteville, NCBuilt 1961 · S/N 22-8641N5029ZSvec Adolph Ralph · Marengo, ILBuilt 1961 · S/N 22-8647N5030ZBoring Walter A · Appomattox, VABuilt 1961 · S/N 22-8648N5031KDexter Fred H · Live Oak, FLS/N 1282-79N5032GAmelia Reid Aviation LLC · San Jose, CABuilt 1978 · S/N 1283-79N5033ZCada Kenneth C · Phoenix, AZS/N 22-8651N50358Lockhart 50r Partners LLC · Austin, TXBuilt 1978 · S/N 1286-79N5035GLasche James R Jr · Weatherford, TXS/N 1284-79N5035JNewton Justin T · Hurdland, MOS/N 1285-79N5035ZAmish Peter S · Newberry, FLBuilt 1961 · S/N 22-8653N5037ZBoyd Christian K · Corinth, TXBuilt 1961 · S/N 22-8655N50380C P Aviation Inc · Santa Paula, CABuilt 1979 · S/N 1291-79N50384Anderson Donald · Simmesport, LAS/N 1292-79N5038CHonea Richard S · Canton, GABuilt 1979 · S/N 1289-79N5038MMiller Aviation Group LLC · Coon Rapids, MNBuilt 1979 · S/N 1290-79N5039ZWeatherford John A · Kinder, LABuilt 1961 · S/N 22-8659N50428N50428 Inc · Fort Ogden, FLBuilt 1979 · S/N 1299-79N5042EMaitland David L · Naples, FLBuilt 1979 · S/N 1297-79N5042ZSmart Alan G · Lincoln, MEBuilt 1961 · S/N 22-8662N50437Naucler Scott N · Independence, ORBuilt 1979 · S/N 1336-80N5043FSpringer Thomas W · Gulf Breeze, FLBuilt 1979 · S/N 1300-79N5045AHess Daniel J · Wasilla, AKBuilt 1979 · S/N 1318-79N5045CRogers Richard V · Newark, OHBuilt 1979 · S/N 1301-79N5045ZHollis Dustin · Pembroke, KYS/N 22-8667N5047GSmith Benjamin R · Azle, TXBuilt 1979 · S/N 1302-79N5047URio Aero Club · Sun Prairie, WIBuilt 1979 · S/N 1303-79N5047ZVanvalkenburgh Sidney B · Madras, ORS/N 22-8671N50487Eakle James R · Westover, WVS/N 1305-79N5049SFisher Aviation LLC · Wilmington, DEBuilt 1979 · S/N 1307-79N5050HVan Winkle Randy M · Van Buren, MOBuilt 1949 · S/N 11-933N5050ZSyers Jacob L · Canton, GABuilt 1961 · S/N 22-8674N5051GMorris Douglas · Huntsville, ALBuilt 1979 · S/N 1308-79N5051HPelissier Robin R · Jennings, LABuilt 1979 · S/N 1309-79N5052GSchool Of Missionary Aviation Technology · Ionia, MIBuilt 1979 · S/N 1310-79N5053GSimpson Edward G · Seabrook, SCBuilt 1979 · S/N 1312-79N50542Benoit Aerial Spraying Inc · Aroma Park, ILBuilt 1979 · S/N 1315-79N5054BMichaud Martin Robert · Monte Vista, CABuilt 1979 · S/N 1313-79N5054NMorlock Joseph L · Slatington, PABuilt 1979 · S/N 1314-79N5054ZSarver Kevin C · Mineral Wells, TXS/N 22-8678
Back to AD 80-25-02 R2