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.

N1994BGxi Holdings LLC · Fort Worth, TXBuilt 1994 · S/N 27-0186 N199DSIsland Wings Inc · Fort Lauderdale, FLBuilt 1973 · S/N 31-7400980 N199PWJ & C Express Inc · Carbondale, ILBuilt 2017 · S/N T20609506 N199TCStearns Nathaniel · Rochester, NYBuilt 1999 · S/N 3257088 N199TEPxw Services · Greenville, DEBuilt 2015 · S/N T20609199 N19CMRedrock Aviation LLC · Missoula, MTBuilt 2011 · S/N T18209020 N19DKRichardson Cotton Inc · Wilmington, DEBuilt 2015 · S/N 18282374 N19JPSheldon Law Pllc · Scottsdale, AZBuilt 1997 · S/N 4636119 N19KCGrays Bay LLC · Warrenton, ORBuilt 1970 · S/N 274516 N19LMM & M Skyshare LLC · Winter Park, FLBuilt 2024 · S/N T20609790 N19RDDennison Ronald Walton Trustee · San Jose, CABuilt 1966 · S/N 24-4597 N19SCSacred Heart Medical Group Inc · Riverside, CABuilt 2001 · S/N T18208101 N19VGLv4 Aviation LLC · Sheridan, WYBuilt 2009 · S/N 4692108 N1ATAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1974 · S/N 31-7405478 N1GLSmith Alfred N D IV · Lake Wylie, SCBuilt 1967 · S/N 27-3826 N1JQJacquot Daniel C · Colorado Springs, COBuilt 1965 · S/N 24-4327 N1NXBirchwood Farms Inc · Hope Mills, NCBuilt 1962 · S/N TD-536 N1SLHotel Kilo Aviation LLC · Anchorage, AKBuilt 1999 · S/N T20608051 N1SYPacific Fleet Aviation LLC · Rochester, NYS/N 27-7654186 N1THall George E Jr · Hillsborough, NCBuilt 1969 · S/N 60-0014 N1UGRegistered aircraftS/N 32R-7780308 N1WLGray William Loyd Jr · Nashville, TNBuilt 2002 · S/N 4636337 N1WYBultron Cristina · Ocala, FLBuilt 1964 · S/N 24-4018 N200CEBrewer Erich J · Thompson, MOBuilt 1977 · S/N 14257 N200CTAlpha Bravo 1 LLC · Willow Street, PABuilt 1989 · S/N 27-0016 N200CXPotter Aviation LLC · Milford, NJBuilt 1984 · S/N 31P-8414042 N200HMBill Keck Aviation LLC · Marlow, OKBuilt 1975 · S/N 32R-7680025 N200JEBloch Gregory S · Xenia, OHBuilt 2011 · S/N 4636501 N200JPBlacklist LLC · Lake Norden, SDBuilt 2014 · S/N 4636649 N200MAlliance Aircraft Group LLC · Denver, COS/N H-11 N200P10x Aviation Partners LLC · Stuart, FLBuilt 1980 · S/N 31-8052124 N200SJChanney Aviation Group LLC · Las Vegas, NVBuilt 1981 · S/N 318152054 N200VMBaker Creek Enterprise · Townsend, GABuilt 1976 · S/N 32R-7780073 N20135Africair Inc · Miami, FLBuilt 2025 · S/N T20609825 N201NKHelms John Broward II · Bartow, FLBuilt 1972 · S/N 27-4816 N202DSValiair Lc Trustee · Casper, WYBuilt 1978 · S/N 31-7912025 N202JHPerrin Michel · Austin, TXBuilt 1973 · S/N 3145 N202MCBeemer Companies · Fairmont, MNBuilt 2011 · S/N T20609030 N20352035 Holdings LLC · North Las Vegas, NVBuilt 2007 · S/N 3257462 N2039XMeister James Emmett · New Richmond, WIBuilt 1996 · S/N 27-0224 N203AMInternational Jets Inc · Gig Harbor, WABuilt 1979 · S/N 31-7912037 N203CAStrasbaugh Development Corp · San Luis Obispo, CABuilt 1997 · S/N 4636102 N203DBSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2024 · S/N T18209130 N203SJCorrado Christopher · Newton, NJS/N 32-40037 N203SPColorado State Patrol · Denver, COBuilt 2011 · S/N T18209040 N2047CPropp & Wings LLC · Missoula, MTBuilt 2005 · S/N T18208445 N20489Lone Oak Properties LLC · Flagstaff, AZBuilt 2005 · S/N T18208446 N2049PVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N T18208448 N204JHLivin The Dream Too LLC · St Paul, MNBuilt 2006 · S/N T20608638 N204PCHestertown Aviation LLC · Monroe, GABuilt 1973 · S/N 32-7440036

Back to AD 71-13-01 R1