Registered aircraft · 6,916

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

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:71-13-01-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:71-13-01-R1') ORDER BY n_number

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:71-13-01-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:71-13-01-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.

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:71-13-01-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:71-13-01-R1')
ORDER BY n_number

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N765LMLangdon Adam · Omaha, NEBuilt 1999 · S/N 27-0269 N7669VYpma Gene A · Harrison, MTBuilt 1968 · S/N 1397 N766CFAirplane Five LLC · Miami, FLBuilt 1973 · S/N 31-7305102 N766SHDaystar Aviation LLC · North Canton, OHBuilt 2011 · S/N T18209050 N766TMRed Baron Leasing LLC · Santa Barbara, CABuilt 2022 · S/N T20609702 N766VKWave Golf LLC · Kimberly, ALBuilt 1977 · S/N 32R-7780271 N7671FPedal Valves Inc · Luling, LABuilt 1976 · S/N 32-7740016 N7678VHinckley David D · Belton, TXBuilt 1968 · S/N 1406 N767CVNcv LLC · Jacksonville, FLBuilt 2001 · S/N 3257234 N767RJS&S Aircraft Inc · Bennington, VTBuilt 1964 · S/N 27-2651 N767RTVan Bortel Aircraft Inc · Arlington, TXBuilt 2023 · S/N T18209107 N767SCClegg Stephen A · Port Orange, FLBuilt 1977 · S/N 27-7754060 N7688Jte Properties LLC · Azle, TXBuilt 1996 · S/N 4636055 N768BKBjk Air Holdings LLC · Springfield, MOBuilt 2023 · S/N T20609752 N768CPCivil Air Patrol · Maxwell Afb, ALBuilt 2007 · S/N T18208786 N768CSAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2012 · S/N T18209068 N768PEMts Inc · Middletown, DEBuilt 1977 · S/N 31-7712037 N7692FCwh Properties LLC · Falls City, NES/N 32R-7780080 N7694LLowell Darryl S · Anchorage, AKBuilt 1973 · S/N 31-7305024 N7696VBoeing Co · Renton, WABuilt 1968 · S/N 1424 N7698C98charlie LLC · Van Wert, OHBuilt 1975 · S/N 32R-7680059 N769CRPromethium LLC · Big Spring, TXBuilt 2023 · S/N T18209109 N769GSSkylar Aviation LLC · Hagerhill, KYBuilt 1977 · S/N 32R-7780236 N769LZMontana 1204 LLC · Rock Valley, IABuilt 2003 · S/N 3255012 N76AWPacific Fleet Aviation LLC · Rochester, NYBuilt 1975 · S/N 27-7554100 N76EHMitchell Matthew J · Penn Yan, NYBuilt 1975 · S/N 32R-7680034 N76FR76 Freedom LLC · Greenville, INBuilt 1977 · S/N 32R-7780317 N76HDArkansas Department Of Transportation · Little Rock, ARBuilt 2014 · S/N T20609140 N76JNGross Charles C III · Mims, FLBuilt 1976 · S/N 31-7652176 N76WSSchulze Allen · Caledonia, MNBuilt 2026 · S/N T20609849 N770BHFernando Baeza · Anthony, NMBuilt 2005 · S/N 27-0342 N770BKHorizon Dreams LLC · Homer, GABuilt 1969 · S/N 27-4296 N770KTInterprime Air Inc · Doral, FLBuilt 1975 · S/N 31-7552053 N7711MStauffer Michael S · Wichita Falls, TXBuilt 1965 · S/N 27-2936 N7712FRice Robert Dalton · Kerrville, TXBuilt 1976 · S/N 32R-7780082 N7716PWhite Donald R · La Ward, TXFirst renewal noticeBuilt 1962 · S/N 24-2929 N771LMBruntjen Eric · Decatur, ILBuilt 1982 · S/N 32R-8229044 N771SPIllinois State Police · Springfield, ILBuilt 2024 · S/N T20609769 N7729VNew England Soaring Tug LLC · Perkinsville, VTBuilt 1969 · S/N 1480 N772DLClik Services LLC · Forestdale, MABuilt 1981 · S/N 318152007 N772DSCharleston Aviation Inc · Charleston, ILBuilt 2002 · S/N 4636338 N772SDWallace Robert L II · Anderson, SCBuilt 1978 · S/N 32R-7887246 N7734AArnold Dean C · Chapel Hill, NCBuilt 2011 · S/N 4692162 N7735PVickers Tim F · Huntingdon, TNBuilt 1961 · S/N 24-2949 N773HPFlorida Highway Patrol · Tallahassee, FLBuilt 2000 · S/N T20608180 N773JSRjb Aviation LLC · Newark, DEBuilt 1989 · S/N 4622073 N773MEConcord Flying Club LLC · Concord, NCBuilt 2015 · S/N 4636684 N773PDLria Leasing LLC · Yakima, WABuilt 2023 · S/N 4636833 N773PTRegent Trust Co Trustee · Wichita, KSBuilt 1973 · S/N 27-7305144 N773WAEquipment Asset Management Corp · Huntington, TXBuilt 2020 · S/N 4636773

Back to AD 71-13-01 R1