OpenAirDocs.org
AD 80-25-02 R2

Registered aircraft · 6,348

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.

N1451Shaughnessy Thomas E · Seabrook, NHBuilt 1953 · S/N 18-2259N1452RBlanton Eric W · Santa Anna, TXBuilt 1975 · S/N AA1B-0552N1453RUnderwood David W · Nampa, IDBuilt 1975 · S/N AA1B-0553N1458RManning Ryan E · Watsonville, CAS/N AA1B-0558N145RWHolder Robert W · Pittsfield, PABuilt 1971 · S/N 800-71N145TNewcomb Robert E · Greenfield, INBuilt 2021 · S/N 6-4971N1461RDawson Electric Works Inc · Armstrong, IABuilt 1975 · S/N AA1B-0561N146MRiddles Michael P · Poulsbo, WABuilt 1946 · S/N 12-703N1475Magee Richard A · Virden, ILBuilt 1970 · S/N 41N1477RWinski Robert L · Durango, COBuilt 1975 · S/N AA1B-0577N1479RRosebecke Jason Eugene · Borger, TXBuilt 1975 · S/N AA1B-0579N147AMVarini Ettore · Fort Worth, TXBuilt 1997 · S/N LE-3760-AMN147TScrobola James M · Wyoming, PABuilt 1953 · S/N 18-2261N1481RMccord Hal E Jr · Pensacola, FLS/N AA1B-0581N1482RDavids Samuel W · Woodinville, WABuilt 1975 · S/N AA1B-0582N1483RLeduc Thomas E · Monterey, CABuilt 1975 · S/N AA1B-0583N1484RLopez Alfred M · Banning, CABuilt 1975 · S/N AA1B-0584N1485RBreeden Wayne M · Memphis, TNBuilt 1975 · S/N AA1B-0585N1486RRiley Daniel B · Valparaiso, INBuilt 1975 · S/N AA1B-0586N1487RShepard William E · Peoria, AZS/N AA1B-0587N1489RSkidmark Services Inc · Debary, FLBuilt 1975 · S/N AA1B-0589N148BSHodges Mitchell · Powder Springs, GABuilt 2004 · S/N 20-1030N148TRegistered aircraftBuilt 1953 · S/N 18-2262N1491RHerring Deems · Pine Mountain, GABuilt 1975 · S/N AA1B-0591N1492RHacker Delbert M Jr · Granbury, TXS/N AA1B-0592N1497RAnthonson Douglas Etal · Cortland, NYS/N AA1B-0597N1498RPedersen Paul C · Barbourville, KYBuilt 1975 · S/N AA1B-0598N14BNSammeter Bryce E · Gilbert, AZS/N 0001N14CSSorknes Chadly S · North Palm Beach, FLBuilt 1974 · S/N AA1B-0355N14FATerran Aviation LLC · Kissimmee, FLBuilt 1972 · S/N AA1A-0366N14HRRegistered aircraftBuilt 1947 · S/N 12-2853N14SKHillsboro Aero Academy LLC · Hillsboro, ORBuilt 1979 · S/N 15283422N1500JBent James L Jr DBA · Palatine Bridge, NYS/N 18-294N1509RHarris Luke · Hampstead, NCS/N AA1B0659N1511EPatton D Pettijohn · Wasilla, AKBuilt 1946 · S/N 7AC-5074N1518RLong Kevin R · Stanton, MIBuilt 1976 · S/N AA1B0658N1522Horn Rebecca M · West Linn, ORS/N 1099N152APGood Life Aviation LLC · San Tan Valley, AZBuilt 1982 · S/N A1521015N152AWYouth Missions Aviation Academy Inc · Southlake, TXBuilt 1985 · S/N 15285977N152AZRegistration Pending · Long Beach, CARegistration pendingBuilt 1979 · S/N 15283886N152BBJensen Harold G · San Antonio, TXBuilt 1979 · S/N 15283831N152BJMissionaire LLC · Kennedy, NYBuilt 1982 · S/N 152-85670N152BMPluska Paul · Hansville, WABuilt 1978 · S/N A1520831N152BPBaker John A · Cape Coral, FLBuilt 1977 · S/N 15281066N152CJFoss Fred C · Naperville, ILBuilt 1978 · S/N 15281682N152DMHolladay Aviation LLC · Jacksonville, FLBuilt 1978 · S/N 15280302N152DXCastracane Mark A · Hattiesburg, MSBuilt 1984 · S/N 15285886N152DZPopovitch Michael P · Marina, CABuilt 1978 · S/N 15281491N152EF47 North Aviation LLC · Wenatchee, WABuilt 1979 · S/N 15283975N152ERAviat Aircraft Inc · Afton, WYBuilt 1978 · S/N 15282469
Back to AD 80-25-02 R2