Skip to content

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.

N6251AKma Air Venture LLC · Fontana, WIBuilt 2008 · S/N T18208852 N6251KSutton Aircraft Salvage LLC · Palmer, AKBuilt 2008 · S/N T20608832 N6253YMidwest Air LLC · Hartford, SDS/N 27-3491 N62546Kurtz Benjamin · Steamboat Springs, COBuilt 1999 · S/N T20608104 N62557Yukon Intermountain Inc · Anchorage, AKBuilt 1976 · S/N 27-7654037 N62564Del Mar College · Corpus Christi, TXBuilt 1976 · S/N 27-7654044 N6257YDavila Rudolfo G · Runge, TXS/N 27-3497 N6258XJ & S Aviation LLC · Fairview, OKBuilt 1961 · S/N 500B-1155-84 N62593Samco USA LLC · Reno, NVBuilt 1976 · S/N 27-7654071 N62599Raw Enterprises Inc · Lewes, DEBuilt 1976 · S/N 27-7654077 N6259TRhys Vineyards LLC · Woodside, CABuilt 2008 · S/N T18208853 N625HADenventures Aviation LLC · Wheat Ridge, COBuilt 2006 · S/N T18208626 N625PLGv Air Inc · Medford, ORBuilt 2007 · S/N T20608787 N625TALandeco LLC · Fincastle, VABuilt 2006 · S/N T20608625 N62615Chopaire LLC · Decatur, ALBuilt 2008 · S/N T18208854 N6261LWoodward Aviation LLC · Alpine, TXBuilt 2004 · S/N T18208289 N6261RGray Joseph C · San Diego, CABuilt 2004 · S/N T18208290 N6261XLines Gary K · Glendale, AZBuilt 2004 · S/N T18208292 N62625Registration Pending · Buffalo, MNRegistration pendingBuilt 1976 · S/N 27-7654095 N6263JMcclain Family Cellars Inc DBA · Irvine, CABuilt 1976 · S/N 32R-7680344 N62647Pacific Fleet Aviation LLC · Rochester, NYBuilt 1976 · S/N 27-7654112 N62650Lpc Aviation Inc · Punta Gorda, FLBuilt 1976 · S/N 27-7654115 N62654Skylens LLC · Hammond, LABuilt 1976 · S/N 27-7654120 N62665Murvin Theoren J III · Winter Garden, FLBuilt 1976 · S/N 27-7654129 N62677Kersey Brian A · Pulaski, TNS/N 27-7654136 N6267KMill Boys Flying LLC · Wilmington, DES/N 477 N62688Blair Leonard · Fleetwood, PABuilt 1976 · S/N 27-7654144 N62697Edwards Benjamin F · La Canada, CABuilt 1976 · S/N 27-7654155 N62699Antelope Valley College · Lancaster, CAS/N 27-7654156 N6269YN6269y Six Place LLC · Miami, FLBuilt 1966 · S/N 27-3513 N626ARHunsicker Calvin E · Fryeburg, MEBuilt 2021 · S/N 4636782 N626BFVenture North Aviation LLC · Cloquet, MNBuilt 1976 · S/N 27-7654108 N626DBJims Air LLC · Oconomowoc, WIBuilt 2004 · S/N T20608503 N626GHSwordfish Enterprises LLC · Avenue, MDBuilt 2017 · S/N T20609525 N626LSHollendonner Keith · Markleville, INBuilt 2005 · S/N T18208405 N626PDC S A Inc · Ogallala, NEBuilt 2006 · S/N T18208547 N626RNFerguson & Son Inc · Lebanon, TNBuilt 1967 · S/N 32-40246 N626SPJoye Robert M · Casa Grande, AZBuilt 1976 · S/N 27-7654094 N626VBJbo Airventures LLC · Saint Petersburg, FLBuilt 1995 · S/N 27-0197 N62707Registration Pending · Piedmont, SCRegistration pendingBuilt 1976 · S/N 27-7654163 N6273JLance J Piper LLC · Green Bay, WIBuilt 1976 · S/N 32R-7680346 N62756Red State LLC · Daytona Beach, FLBuilt 1976 · S/N 27-7654202 N6278AJohnstone Jon T · Brentwood, CABuilt 2008 · S/N T18208864 N6279AVpc Aviation LLC · Cartersville, GABuilt 2008 · S/N T18208865 N627AXSky Ridge Transport LLC · Anaheim, CABuilt 2002 · S/N 4636341 N627DYColtov LLC · San Diego, CABuilt 1999 · S/N 4636247 N627JKUlrich Sandy J · Haskell, OKBuilt 1966 · S/N 27-3223 N627MADestination Alaska Air Service LLC · Homer, AKBuilt 1975 · S/N 31-7512055 N627PABig Sky Leasing LLC · Johnson, KSBuilt 2014 · S/N 4636627 N62801Pacific Fleet Aviation LLC · Rochester, NYBuilt 1976 · S/N 27-7754032

Back to AD 71-13-01 R1