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.

N54MVNeil Anthony Foster Holdings LLC · Santa Rosa, CABuilt 1976 · S/N 27-7654043 N54SSNinja Turtle LLC · Fuquay Varina, NCBuilt 1978 · S/N 32R-7885254 N54STMac Air Aviation LLC · Xenia, OHBuilt 1974 · S/N 27-7405358 N54WAWright Air Service Inc · Fairbanks, AKBuilt 1976 · S/N 31-7652067 N54ZAWestside Gas Inc · Tucson, AZBuilt 2012 · S/N T20609082 N5502YCreative Strategies Inc · Grayson, KYBuilt 1964 · S/N 27-2596 N55050Newman Jeffrey M · Pauline, SCBuilt 1973 · S/N 32-7340097 N55089Zitren Frederick J · El Cajon, CABuilt 1973 · S/N 32-7340100 N550CADubin Donald · Salida, COBuilt 2018 · S/N 4636736 N550CPCivil Air Patrol · Maxwell Afb, ALBuilt 2020 · S/N T20609617 N5513NBig Blue Aviation LLC · Pinehurst, NCBuilt 1980 · S/N 18267764 N55159Rasmussen Paul H · Mitchell, SDBuilt 1973 · S/N 32-7340103 N551HPMotorcarlease USA Inc · Miami Beach, FLBuilt 2001 · S/N T20608286 N551SPIllinois State Police · Springfield, ILBuilt 2024 · S/N T20609766 N551TTSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1997 · S/N 3257026 N55209De Cuir Dennis W · Incline Village, NVBuilt 1973 · S/N 32-7340105 N5524CStewart Kyle · Santa Barbara, CABuilt 2013 · S/N T20609116 N5525RJwh Dalton Holdings LLC · Brentwood, TNBuilt 2014 · S/N T20609141 N552DCAki H Korhonen · Reno, NVBuilt 2004 · S/N 27-0329 N552JAAv8r Flying Club LLC · Warsaw, INBuilt 1967 · S/N 32-40147 N552MNMtc Air LLC · Blue Ridge, GABuilt 2005 · S/N 18281588 N552TMPerry Park Investments Inc · Larkspur, COBuilt 2026 · S/N T20609847 N5533YAce Tomato Co LLC · Daytona Beach, FLBuilt 1964 · S/N 27-2631 N55360Ball Duke Allen · Drakesville, IABuilt 1973 · S/N 32-7340113 N553CBravo Air LLC · Frisco, TXBuilt 1991 · S/N 270105 N553HCHotel Charlie LLC · Dallas, TXBuilt 2004 · S/N T18208287 N553HPCalifornia Highway Patrol · Sacramento, CABuilt 2006 · S/N T20608633 N553TCHawksley LLC · Bozeman, MTBuilt 2004 · S/N T20608487 N5543SCascade Marine Holdings Inc · Terrebonne, ORBuilt 1978 · S/N 32R-7887031 N5545YKolarek Frank · West Nyack, NYFirst renewal noticeBuilt 1964 · S/N 27-2644 N554KDWestern Air International Co · Pompano Beach, FLBuilt 1979 · S/N 31-7952157 N55510Western Community College Area DBA · Scottsbluff, NES/N 1252 N555BPBayusik Kevin R · Shelton, CTBuilt 1980 · S/N 32R-8029072 N555BWZia Air LLC · Hagerman, NMBuilt 1974 · S/N 61P-0168-007 N555FSJacko Josh E · Anchorage, AKBuilt 1978 · S/N 31-7952046 N555GTRegistered aircraftBuilt 1979 · S/N 31-7952148 N555HRJtu Aviation LLC · Laramie, WYBuilt 2005 · S/N 27-0333 N555JGLeia Air LLC · Wilmington, DEBuilt 1979 · S/N 31-8012018 N555JVColumbia Recreation LLC · Quincy, WABuilt 2000 · S/N 4636270 N555MBOpus Partners LLC · Orlando, FLBuilt 2018 · S/N 4636722 N555MFCloud 555 Inc · Wilmington, DEBuilt 1980 · S/N 31-8012068 N555NVCaladesi Financial Inc · Palm Harbor, FLBuilt 2008 · S/N T18208869 N555PRHarlan Thomas D · Fresno, CABuilt 1969 · S/N 27-4248 N555RUHands Holding · Newark, DEBuilt 1981 · S/N 32R-8129114 N555SSSkylink Group LLC · York, PABuilt 1976 · S/N 14045 N555TPNugget Investments LLC · Strongsville, OHBuilt 1979 · S/N 32R-8029041 N555UWMcdaniel John D Jr · Leesburg, GABuilt 1978 · S/N 32R-7887117 N555VSMcgregor Daniel A · Denali Park, AKBuilt 1971 · S/N 31-791 N55629Mccarthy Robert · Farmers Branch, TXS/N 32-7340128 N55664Cherokee 55664 LLC · Sparks, NVBuilt 1973 · S/N 28-7310145

Back to AD 71-13-01 R1