Registered aircraft · 6,915

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.

N2439SBright Scott Devin · Platteville, COBuilt 2006 · S/N T18208528 N243MCRankin John · Nokomis, FLBuilt 2004 · S/N T18208243 N243PSN9089 LLC · Lewes, DES/N 3257073 N2440PN2440p LLC · Seattle, WABuilt 1999 · S/N T20608136 N2440VVehrs Roger K · Roseburg, ORBuilt 2000 · S/N T20608176 N2441GTognoli Stefano F · Union, ORBuilt 2000 · S/N T20608173 N2441MBlackburn Alan Ryan II · Palm City, FLBuilt 1979 · S/N 27-7954059 N2441YTag Aviation LLC · Santa Teresa, NMBuilt 2000 · S/N T20608169 N2444NHoliday Aviation LLC · Marathon, FLBuilt 2011 · S/N 4692172 N2446ESugarloaf Air LLC · Wilmington, DES/N T20608580 N2447EWingnut Aviation LLC · Fort Lupton, COS/N T18208767 N24480Moscair LLC · Nashville, TNBuilt 2001 · S/N 18280932 N244ACScruggs Ken · Galloway, OHBuilt 1968 · S/N 1815-21 N244CJPaula Stewart LLC · Saipan, MPBuilt 2017 · S/N GA8-TC-320-17-239 N244LMSunset Horizons LLC · Clovis, CABuilt 2012 · S/N 4636531 N244MEEagle Forestry Services Inc · Monticello, ARS/N T20608192 N244RWeiser Inc · Minburn, IABuilt 1973 · S/N 27-7305025 N24507Pena Jairo · Catharpin, VABuilt 1999 · S/N T20608038 N2451YSalmon Michael J Trustee · Albuquerque, NMBuilt 2007 · S/N T20608759 N2454FOlson Donald C · Golovin, AKS/N 27-2666 N2455XRucker Aviation Logistics Inc · Shingle Springs, CABuilt 1999 · S/N T20608121 N24569Pt Logistics LLC · Rye, NHBuilt 2000 · S/N T20608209 N2456HPappusgrass Aviation LLC · San Antonio, TXBuilt 1999 · S/N T20608124 N245AGMummey Jose Pablo · Everett, WAS/N 27-7305187 N245BTMichael Knapp · Galveston, TXBuilt 2025 · S/N T20609804 N245EABlue Heron Aviation LLC · Port Orange, FLBuilt 2021 · S/N 4636777 N245LCImage Craft LLC · Phoenix, AZBuilt 2001 · S/N 2045 N245MAJc Aviation LLC · Bedminster, NJBuilt 2001 · S/N 3257215 N245SSharpaire LLC · Wilmington, DEBuilt 1997 · S/N 4636104 N24607Fey Properties LLC · Pleasanton, CABuilt 2001 · S/N T20608277 N2461FDietz Thomas · Mill Valley, CABuilt 1999 · S/N T20608119 N2461MAbdulla Urooj · Damon, TXBuilt 1977 · S/N 32-7840049 N2464CCantera La Rita Inc · San Juan, PRBuilt 2005 · S/N T20608584 N2468YGv Air Inc · Medford, ORBuilt 2011 · S/N T20609005 N2469H69h LLC · Ocean City, MDBuilt 2025 · S/N T20609822 N246APT & N Holdings LLC · Tyler, TXBuilt 2019 · S/N T20609564 N246LRegistered aircraftBuilt 2023 · S/N 4636825 N246SECannavair Inc · Seattle, WABuilt 2007 · S/N T18208688 N2470FMeridian Aviation LLC · Lincolnton, NCBuilt 2000 · S/N 18280890 N2470PFisher Air LLC · Cardington, OHBuilt 2000 · S/N 18280891 N24747Peachey Farms LLC · Decatur, IABuilt 2001 · S/N T18208038 N2477XLecce Aviation LLC · Williamsport, PABuilt 2007 · S/N T20608762 N2478AEnnair LLC · Kalispell, MTBuilt 2007 · S/N T20608763 N2478DAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2007 · S/N T18208775 N247CTConsolidated Technologies · Woodbury, MNBuilt 1961 · S/N 320-0058 N248KCracker Aviation LLC · Jupiter, FLBuilt 1975 · S/N 27-7654004 N248RCMckinley I Blake Jr · Spokane Valley, WAFirst renewal noticeBuilt 1999 · S/N T20608141 N248RRWalter Air Co LLC · Oakdale, CABuilt 2004 · S/N T20608481 N249CPearson Aviation LLC · Montoursville, PABuilt 2008 · S/N 4692023 N249FBK4m Aviation LLC · Marksville, LABuilt 1999 · S/N 4636221

Back to AD 71-13-01 R1