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.

N5388ZHarcourt Tim J · Libby, MTBuilt 1961 · S/N 22-9157N53891Settle Paul W · Virden, ILBuilt 1975 · S/N 1139-76N53893Amelia Reid Aviation LLC · San Jose, CABuilt 1975 · S/N 1140-76N53898Georgescu Paul F Jr · Carmel, INBuilt 1976 · S/N 1141-76N5389HBlessum Jay A · Minot, NDBuilt 1949 · S/N 16-196N5389MChapel Hill Flying Club DBA · Sanford, NCBuilt 1980 · S/N 15284576N5389QCieri Joe · Graves Mill, VABuilt 1981 · S/N 15285107N5390HRidgway Rick J · Carlisle, INBuilt 1949 · S/N 16-197N53918N53918 LLC · Charles City, IABuilt 1976 · S/N 1145-76N53923Little Dale E · Marshville, NCBuilt 1976 · S/N 1146-76N5392HDeno Douglas · Battle Creek, MIBuilt 1949 · S/N 16-199N5392ZSteed Brian · Winnsboro, SCBuilt 1961 · S/N 22-9162N5393HMacpherson Roni J · Cardiff By The Sea, CABuilt 1949 · S/N 16-201N5394BRichmor Aviation Inc · Hudson, NYBuilt 1979 · S/N 15283859N53952Oancea Traian · Oakdale, CABuilt 1976 · S/N 1150-76N53962Hatbright Farm LLC · Wilmington, DES/N 115276N5396ZCollins Dennis L · Richland, WABuilt 1961 · S/N 22-9166N5397ZSchutze Richard P · Ojai, CABuilt 1961 · S/N 22-9167N53983Johnson David H · Jasper, GABuilt 1976 · S/N 1157-76N53986Flyit LLC · Camas, WABuilt 1976 · S/N 1158-76N53988Jensen Marian D · Auburn, WABuilt 1976 · S/N 1161-76N5399BLudian Malgorzata · Bakersfield, CABuilt 1979 · S/N 15283861N5399HKling Edward V · St Charles, ILBuilt 1949 · S/N 16-206N539BXin Han Aviation LLC · Atwater, CABuilt 1979 · S/N 15283898N53BSAloft Technologies Inc · Maple Grove, MNBuilt 1979 · S/N 38-79A0793N53LCCramer Todd L · Fort Mohave, AZBuilt 2020 · S/N 001N5403HWings Over Texas Holdings LLC · Denton, TXBuilt 1979 · S/N 15284096N5404BRichmor Aviation Inc · Hudson, NYBuilt 1979 · S/N 15283862N5405BNatkat Aviation Services LLC · Finleyville, PABuilt 1979 · S/N 15283863N5405MToozer Air LLC · Ormond Beach, FLBuilt 1980 · S/N 15284581N5406ZRains Kenneth W Jr · Lebanon, TNFirst renewal noticeBuilt 1961 · S/N 22-9178N5407HPye Jennifer · Roanoke, TXBuilt 1949 · S/N 14-522N540ACChristians Ricky P · Appleton, WIBuilt 1977 · S/N 1206-77N540GTMatthews Guy · Geneseo, NYBuilt 1974 · S/N AA1B-0460N5410ZHillhorst Kenneth E · Rocky Mount, NCBuilt 1961 · S/N 22-9183N5413ZBehr Casper J · Neavitt, MDBuilt 1961 · S/N 22-9186N5414ZNess Jon D · Lakeville, MNBuilt 1961 · S/N 22-9187N5416BLong Island Aviators LLC · Seaford, NYS/N 15283867N5417ZLack James A · Homer, AKBuilt 1961 · S/N 22-9190N5418ZWare Joseph B · Angleton, TXBuilt 1961 · S/N 22-9191N541MERegistered aircraftBuilt 2007 · S/N 1400-2007N541PGHiggins Bennett P · Dedham, MEBuilt 2015 · S/N 1903N5420POklahoma State University · Stillwater, OKBuilt 1981 · S/N 15284942N5420ZAthey Jeff R · Friendswood, TXBuilt 1961 · S/N 22-9193N5421PRiverside Flight Center Inc · Tulsa, OKBuilt 1981 · S/N 15284943N5423ZBergstrom Lindsay B · Plymouth, MNS/N 22-9197N5424ZGavlik Joseph A II · Lincoln, RIBuilt 1961 · S/N 22-9198N5427ZRegistration Pending · Dothan, ALRegistration pendingBuilt 1961 · S/N 22-9201N5428LMacair Aviation LLC · Xenia, OHBuilt 1980 · S/N 15284313N542EZLesher Caleb J · Cottonwood, CAS/N 80
Back to AD 80-25-02 R2