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.

N726ECHeritage Aviation Management Ltd · Conroe, TXBuilt 2021 · S/N T20609635 N726GMNby Productions · Bristow, VABuilt 2021 · S/N T20609644 N726MPBryant Darrell · Treasure Island, FLBuilt 2023 · S/N T20609751 N726TBRead Russell P · Missoula, MTBuilt 2002 · S/N 2151 N7270VAirmotive Service LLC · Brigham City, UTBuilt 1967 · S/N 1320 N7273ZRegistration Pending · Canyon Lake, TXRegistration pendingBuilt 1999 · S/N T20608084 N7274C182 Flight Corp · Bronx, NYBuilt 1999 · S/N T20608059 N72758Hinton Larry L · Kirkland, WABuilt 2001 · S/N T18208004 N72768Tjs Rentals LLC · Glasgow, MTBuilt 2000 · S/N T20608146 N7277NTodom Air LLC · Anchorage, AKS/N T20608070 N7278CAndrews Jeb C · Monroe, LABuilt 1975 · S/N 32R-7680044 N72795Sides Enterprises LLC · Anthony, NMBuilt 1999 · S/N T20608092 N727CEHuston Aviation LLC · Fort Worth, TXBuilt 2008 · S/N 4692064 N727CGOwens Keith E · Wrightstown, NJBuilt 2000 · S/N 18280838 N727CJMgr Aviation LLC · Chelsea, MIBuilt 1976 · S/N 14181 N727DKLobbytools Aviation LLC · Friday Harbor, WABuilt 2007 · S/N T20608768 N727HBRiverside Farms · Sardis, MSBuilt 1980 · S/N 31-8112006 N727KWilliam L Schmidt Attorney At Law Pc · Fresno, CABuilt 1994 · S/N 4622178 N727MAMarc Inc · Bolton, MSBuilt 1976 · S/N 31-7652048 N727RLHammerton Kenneth R · Olive Branch, MSBuilt 1976 · S/N 31-7612056 N727SDStable Air LLC · Leonardtown, MDBuilt 1976 · S/N 32R-7780060 N727TVTuskegee Eagles Of St Jeseph Mo · Agency, MOS/N 74-31081 N72805Ace Aviators LLC · New Baltimore, MIBuilt 2000 · S/N T20608254 N7280ZGalt Ranch Aviation LLC · Wht Sphr Spgs, MTBuilt 1999 · S/N T20608079 N72819Mccune Ken · Lake Havasu City, AZBuilt 2000 · S/N T20608252 N728AABrinckerhoff Allen D · Windermere, FLBuilt 2004 · S/N T18208249 N728CAPremiere Aviation Inc · Wilmington, DEBuilt 1976 · S/N 31-7752035 N728MPNational Aircraft Leasing Corporation · Greenville, DEBuilt 2009 · S/N T20608914 N728TAWbl Air II LLC · Minneapolis, MNBuilt 2008 · S/N T20608829 N7294PMcnamara Pa · Far Hills, NJBuilt 1978 · S/N 27-7854072 N72CEChad A Mcgowan Pc · Rock Hill, SCBuilt 2025 · S/N T20609824 N72DNPostiglione Daniel · West Babylon, NYBuilt 1971 · S/N 24-5006 N72FAJones Donald T Jr · Barrigada, GUBuilt 1977 · S/N 31-7812023 N72FMBank Of Utah Trustee · Salt Lake City, UTS/N 27-0264 N72RKAerial Services Inc · Cedar Falls, IABuilt 2001 · S/N T20608315 N72SB72 Sierra Bravo LLC · Allegany, NYBuilt 1971 · S/N 24-4969 N72SDYooper Aviation LLC · Menominee, MIBuilt 1972 · S/N 32-7240099 N72ZGSale Reported · Hood River, ORSale reportedBuilt 2006 · S/N T20608700 N730MCCpc2 Aviation LLC · Hoover, ALBuilt 1965 · S/N 27-3097 N731WN64gs LLC · Van Nuys, CABuilt 1971 · S/N 24-4989 N7332VLorenz William D · Benson, MNBuilt 1969 · S/N 32-1 N7335TNever Repress Laughter LLC · Villa Rica, GABuilt 1977 · S/N R18200029 N733GPHorton Luther · Lakeland, FLBuilt 1962 · S/N 24-3213 N733KMKhm LLC · Chardon, OHBuilt 2016 · S/N T20609226 N735CPCivil Air Patrol · Maxwell Afb, ALBuilt 2019 · S/N T20609571 N735QStuart Aviation Holdings LLC · Stuart, FLBuilt 1978 · S/N 31-7812089 N735RCSoto Flavio Cesar · Nogales, AZBuilt 1998 · S/N 4636167 N736XPsa LLC · Fort Myers, FLBuilt 1973 · S/N 32-7340095 N7377GMcafee K Scott · Missoula, MTBuilt 2023 · S/N 4636823 N737EBVx Ventures LLC · Castle Rock, COBuilt 2002 · S/N T18208135

Back to AD 71-13-01 R1