OpenAirDocs.org
AD 80-25-07 R1

Registered aircraft · 25,369

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-07-R1')
    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-07-R1')
  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.

N713SJKoerner James L Trustee · Gilbert, AZBuilt 1977 · S/N 17269713N71409Piedmont Flight Inc · Winston Salem, NCBuilt 1976 · S/N 17267227N7140BEstep James B · Chillicothe, OHBuilt 1977 · S/N A1520740N7140JCohesive Aviation LLC · Gilford, NHBuilt 1980 · S/N 17273901N7140QMagnuson Jessica M · Olathe, KSBuilt 1972 · S/N 17260440N7140TMurray Robert S Trustee · Shingle Springs, CABuilt 1977 · S/N R18200026N7140VVallejo Noel R · Alpine, UTFirst renewal noticeBuilt 1974 · S/N 21-0049N7141GDyke Paul A · Hartford, SDBuilt 1969 · S/N 17258841N7141JHutt Aviation Inc · Minden, NVS/N 17273902N7141QFlight Time Builders Inc · Memphis, TNBuilt 1972 · S/N 17260441N7141UBlazevic Bojan · Las Vegas, NVBuilt 1964 · S/N 380N7142QObymachow Richard M · Killingworth, CTS/N 17260442N7142UBykowsky Eric · Atlanta, GABuilt 1964 · S/N 381N7142VTarantino Joseph A · Daytona Beach, FLBuilt 1974 · S/N 22-0061N71430Princeton Raptors Flying Club · Princeton, MNS/N 17263380N7143GAllen Nathanael W · Bemidji, MNBuilt 1969 · S/N 17258843N71444Rushville Flying Club Inc · Rushville, ILBuilt 1975 · S/N 172-65662N7144GJc Flight Inc · Wilmington, DEBuilt 1969 · S/N 17258844N7144VJs&J Enterprises LLC · Sapulpa, OKBuilt 1974 · S/N 22-0063N7146GHalladay Roy · Erie, COBuilt 1969 · S/N 17258846N7146QPressley Aviation LLC · New London, NCBuilt 1972 · S/N 17260446N7147GAffordable Flying LLC · Cedar Park, TXBuilt 1969 · S/N 17258847N7147UCurtin Matthew T · Cedar Hills, UTBuilt 1964 · S/N 386N7148UN192ag LLC · Mckinney, TXBuilt 1964 · S/N 387N7148VSs Viking LLC · Saint Augustine, FLS/N 22-0067N7149QS&H Aviation LLC · Columbus, INS/N 17260449N7149UBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 388N7149VLeghorn Aero Services LLC · Waynesboro, VABuilt 1974 · S/N 22-0068N714HPTic Aerospace Inc · Miami, FLBuilt 1982 · S/N 172RG1123N714SWMackin Robert M · Castro Valley, CABuilt 1977 · S/N 15279406N714TAPaterson Fraser · Torrance, CABuilt 1977 · S/N 15279410N714TCJt Air LLC · Luling, LABuilt 1977 · S/N 15279412N714TFK2 Aviation LLC · Somerset, PAS/N 15279414N714TJTop 5 Media LLC · Santa Maria, CABuilt 1977 · S/N 15279417N714TMVetter Brent E · Helena, MTBuilt 1972 · S/N 348-72N714TRStocks Kristian · Billings, MTBuilt 1977 · S/N 15279424N714TUDamschroder Rex A · Fremont, OHBuilt 1977 · S/N 15279427N714UCStroud James DBA · Union, SCBuilt 1977 · S/N 15279435N714UDThunderfighter LLC · Englewood, COBuilt 1977 · S/N 15279436N714UFBoraam Aviation Inc · Prospect Heights, ILBuilt 1977 · S/N 15279438N714VBCrosswinds Flight Center Inc · Drums, PAS/N 15279457N714VGJust Tailwheels LLC · Sarasota, FLBuilt 1977 · S/N 15279462N714VHJet & Rotor Aviation LLC · Sacramento, CAS/N 15279463N714VLOdonata LLC · Lewiston, IDBuilt 1977 · S/N 15279466N714VNFolstad Bennett O · Sidney, MTBuilt 1977 · S/N 15279468N714VWMoore Harry L · Richardson, TXBuilt 1967 · S/N 670441N714VYTappan East LLC · New Philadelphia, OHBuilt 1977 · S/N 15279478N714VZSojka Brian Z · Herndon, VABuilt 1977 · S/N 15279479N714WDDaviation Inc · Willoughby, OHBuilt 1977 · S/N 15279482N714WECirrus Inc · Wilmington, DEFirst renewal noticeBuilt 1977 · S/N 15279483
Back to AD 80-25-07 R1