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.

N710JPSt Matthew Aviation Company LLC · Kalispell, MTBuilt 1979 · S/N 31-7952086 N710JSLeyden Aviation LLC · Dover, DEBuilt 2012 · S/N T20609074 N710KVG B Aerial Applications Inc · Slaton, TXS/N T18208291 N710SMExclusive Aeronautics LLC · Las Vegas, NVBuilt 1994 · S/N 27-0174 N710WKWayne Mogg Inc · Rossmoor, CABuilt 2023 · S/N 4636820 N711BAPresley Louis · Cresson, TXBuilt 1968 · S/N 24-4801 N711BKRoebbelen Contracting Inc · El Dorado Hills, CABuilt 2009 · S/N 4692111 N711BWQualitair LLC Trustee · MichelstadtBuilt 1969 · S/N 24-4877 N711CPKoo Aviation LLC · Woodsfield, OHBuilt 2014 · S/N 4636636 N711JLCentral Iowa Agricultural Aviation LLC · Wellsburg, IABuilt 1973 · S/N 32-7340175 N711LYSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2003 · S/N 2182 N711PFTaylor Monty · Kingfisher, OKS/N 32-7340061 N711STHalabi Aviation 2 LLC · Foster City, CABuilt 2012 · S/N 4692179 N711WZBaker Matthew · Mesa, AZBuilt 1990 · S/N 27-0042 N712AMMaggie Aviation LLC · Phoenix, AZBuilt 2017 · S/N T20609517 N712BLMs Air LLC · Hickory, NCBuilt 2008 · S/N 4692027 N712PWDown The Creek LLC · Grant Valkaria, FLBuilt 1976 · S/N 32R-7680276 N712RJHigh Romance LLC · Belvedere, CABuilt 2007 · S/N T20608705 N7139CGv Air Inc · Medford, ORBuilt 1969 · S/N 31-553 N713ECCharlie Tango LLC · Mechanicsville, VABuilt 1975 · S/N 27-7554151 N713HMPinto Carlos · Tucson, AZBuilt 1977 · S/N 61P-0449-172 N713TRed Rock Airventures LLC · Moab, UTBuilt 2023 · S/N T18209111 N713WTWtw Air LLC · Houston, TXBuilt 1977 · S/N 31-7752138 N714KLMatera Management LLC · Spanish Fork, UTBuilt 2002 · S/N 4636328 N715BBMartin L Jeffrey · Hudson, OHBuilt 1996 · S/N 4636038 N715LGGuy Transportation Ltd · Carolina, PRS/N 500B-1174-90 N715LMIntepros Inc · Jupiter, FLBuilt 1998 · S/N 4636173 N7164DAir Arctic Inc · Fairbanks, AKBuilt 1980 · S/N 31-8052013 N716JMAtec Aviation LLC · Jupiter, FLBuilt 2017 · S/N 4636716 N716PRChupond America Inc · Pittstown, NJBuilt 2000 · S/N 27-0305 N716SBDirect Gulf Access LLC · Springfield, MOBuilt 1978 · S/N 32R-7987088 N716TCCentral Airlines Inc · Leawood, KSBuilt 1962 · S/N 500B-1225-102 N717GMAlbatross Aviation LLC · Tazewell, TNBuilt 1997 · S/N 46-36118 N717KWCollins Jeff · Portland, TNBuilt 2016 · S/N T20609249 N717MZMaritz Paul · Mercer Island, WABuilt 1999 · S/N T20608090 N717SKLava Rock Properties LLC · Saint George, UTS/N 4636053 N717UOcean Abaco LLC · Virginia Beach, VABuilt 1983 · S/N 31-8352026 N718JER L Doskocil Inc · Crosby, TXBuilt 2016 · S/N T20609256 N718TDSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2022 · S/N 4636813 N719JGSkyhawk Dev Inc · Ennis, MTBuilt 2026 · S/N T20609834 N719PFuhr David · Wabasso, MNBuilt 1968 · S/N 31-272 N71CEMcgowan Chad · Rock Hill, SCBuilt 2004 · S/N T18208278 N71DPDjp Enterprises Inc · Chandler, TXBuilt 2001 · S/N T18208056 N71FLWest Transportation LLC · West Bloomfield, MIBuilt 1968 · S/N 27-3969 N71JFNigro Air LLC · Las Vegas, NVBuilt 2024 · S/N T20609768 N71JGFred Garrison Oil Co · Plainview, TXBuilt 1970 · S/N 61-0057-106 N71VBStephen Holtzman Consulting LLC · San Luis Obispo, CABuilt 2017 · S/N T20609216 N71WZArlington Aviation Inc Trustee · Wilmington, DEBuilt 2000 · S/N 4636275 N7204CHousley Communications Inc · San Angelo, TXBuilt 1975 · S/N 32R-7680042 N720JBSchoettle Steve P · Heber Springs, ARBuilt 1979 · S/N 32-7940150

Back to AD 71-13-01 R1