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.

N33TLPaloma Uno LLC · Stuart, FLBuilt 1975 · S/N 31-7512043 N33UPAero Valley Properties LLC · Roanoke, TXBuilt 1961 · S/N 320-0078 N33WBSycamore Aviation Services LLC · Terre Haute, INBuilt 1978 · S/N 32R-7987056 N3406A406a Inc · Hollywood, FLS/N 3257044 N340CSTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N T20609840 N340HGVan Haitsma Kelly · Fort Worth, TXBuilt 1973 · S/N 340-0228 N340MASoar Aviation LLC · Rllng Hls Est, CABuilt 2001 · S/N 27-0314 N341BEAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 27-0341 N341CACovenant Air LLC · Wilmington, DEBuilt 1979 · S/N 31-7952243 N341MC1 Mc LLC · Johnstown, PABuilt 1995 · S/N 4636018 N341SW13:4 Aviation LLC · Brookfield, WIBuilt 1969 · S/N 32-40592 N342CSTextron Aviation Inc · Wichita, KSBuilt 2026 · S/N T20609842 N342TSDaniels Law · Sherman Oaks, CABuilt 2001 · S/N T18208040 N343TCTwo Rivers Aircraft Managmenet LLC · Williamsburg, VABuilt 2004 · S/N T18208344 N3441QBluegrass Skyriders LLC · Vine Grove, KYBuilt 1977 · S/N 32-7740063 N344TAJcg-Air LLC · Valdosta, GABuilt 2006 · S/N 3255048 N344TXCline Lyndi · Royce City, TXBuilt 1966 · S/N 24-4478 N344WASorensen Air LLC · Syracuse, UTBuilt 2024 · S/N 4636844 N345CMScherson David Alejandro · Folsom, CABuilt 2010 · S/N T18209016 N345DPBack Country Hacks LLC · Olalla, WABuilt 2001 · S/N T20608269 N345MMMarciaran LLC · Dover, DEBuilt 1990 · S/N 4622112 N345RKButler Management LLC · Sherman Oaks, CABuilt 2007 · S/N T18208790 N345RPMcdole Consulting LLC · Southern Shores, NCBuilt 1990 · S/N 4622096 N345SEPlane Fun Inc Tr Trustee · Snellville, GABuilt 2004 · S/N 3257345 N345WCEnriquez Antonio · Austin, TXBuilt 2023 · S/N T18209105 N3469246dk LLC · Ramona, CABuilt 2004 · S/N T18208248 N346CKCk Contracting Inc · Kings Mountain, NCBuilt 2021 · S/N T20609664 N346JHRobertson Timothy A · Lewistown, MTBuilt 2008 · S/N T20608814 N346TXKurk Mcginley Enterprises Inc · The Woodlands, TXBuilt 2013 · S/N 4692200 N347CBMishock Kevin A · Melbourne, FLBuilt 1976 · S/N 32R-7780002 N347DWSnoopy Air LLC · Branch, LABuilt 1996 · S/N 4636059 N347LSEuroaviation Inc · KematenBuilt 2007 · S/N T18208749 N347SACoastal Carolina Helicopters LLC · Burgaw, NCBuilt 2006 · S/N T18208522 N348PSTim Moyer Management LLC · Whitefish, MTBuilt 2005 · S/N 27-0348 N3495QBoswell Alan · Chrisney, INBuilt 1967 · S/N 320E-0095 N349CHAce Flight Center Inc · St Thomas, VIBuilt 1968 · S/N 27-3949 N349CPCivil Air Patrol · Maxwell Afb, ALBuilt 2011 · S/N T18209029 N349MAMa Sammy · S San Fran, CABuilt 2004 · S/N 3257349 N34FMCordero Jose Robert · El Paso, TXFirst renewal noticeBuilt 1998 · S/N 27-0241 N34MALk Air Inc · Arlington, WAS/N 32-40219 N34PLMoonglow Aviation LLC · Toledo, OHBuilt 2003 · S/N T20608403 N34UMMarathon Skylane LLC · West Palm Beach, FLS/N T18208561 N34WM70 North LLC · Anchorage, AKBuilt 1973 · S/N 31-7305125 N34XTGwk Aviation LLC · Fort Smith, ARBuilt 2005 · S/N 3255034 N3500RSystems Research Corp · Wilmington, DEBuilt 2001 · S/N T18208047 N3502JAv Solutions Inc · Flint, MIS/N T18208058 N3506YCascade Commodities LLC · Saint Paul, MNBuilt 2001 · S/N T20608311 N350ARAbode Construction Inc · Marion, IABuilt 1990 · S/N 4622109 N350AZTuckerman David B · Lake Stevens, WABuilt 2018 · S/N 4636738 N350CAMajors Donald G Jr · Cave Creek, AZBuilt 2002 · S/N 3257279

Back to AD 71-13-01 R1