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.

N3134FSignature Aviation Group LLC · Columbia, MOBuilt 2012 · S/N 4692183 N3138BBuck Enterprises LLC · Henderson, NVBuilt 2006 · S/N 3255044 N313ECCunha Properties Management LLC · Miami, FLBuilt 2011 · S/N T18209052 N313PKCampbell James D · Palo Alto, CABuilt 1976 · S/N 32R-7780037 N313PPMw Collins Inc · Cobbtown, GABuilt 2006 · S/N 3255051 N313RBGlenn Simmons LLC · Point Lookout, NYBuilt 1978 · S/N 32R-7887157 N313RMVan Bortel Aircraft Inc · Arlington, TXBuilt 2005 · S/N T18208456 N3143JLyden Air LLC · Walbridge, OHBuilt 2006 · S/N 3257427 N3147DOrr Calvin L · Higginsville, MOBuilt 1968 · S/N 32-40412 N314K314-K Associates LLC · Stratford, CTBuilt 1983 · S/N 31-8352025 N314MEJfw Ranch Consulting LLC · Albuquerque, NMS/N T20608222 N314PLWkj Enterprises LLC · Boulder, COBuilt 2011 · S/N 4636521 N3151HD S R D Investments LLC · Oklahoma City, OKBuilt 2006 · S/N 3257428 N3158LScott Terrence Lee · Oakland, CABuilt 1994 · S/N 27-0189 N315ENRhino Air LLC · Wilmington, DEBuilt 1977 · S/N 61P-0451-173 N315GFCommander Aviation LLC · New Holland, ILBuilt 2023 · S/N T18209103 N315KTMoonrise Flyers Inc · Port Townsend, WABuilt 2001 · S/N 27-0316 N3163QLakefield Lance Ltd · Coldwater, OHBuilt 1977 · S/N 32R-7780295 N316AAAllman Alice F · Blackstone, VABuilt 1994 · S/N 27-0176 N316ADRude Daniel · Leesburg, VABuilt 2023 · S/N T18209112 N316HABidzy To Hot Aana Corp · Dillingham, AKS/N 31-7652133 N316KUOldenburg Air LLC · Henderson, NVBuilt 2005 · S/N 4636369 N316MABlue Side Up Inc · Islamorada, FLBuilt 1976 · S/N 32-7640112 N316RBRbp Management LLC · Franklin, NCBuilt 2008 · S/N T18208813 N316TGTutton Group LLC · Jasper, GABuilt 2023 · S/N 4636832 N3176HG B T S LLC · Yatesville, GAS/N 31-7300913 N31795Kshr Av8rs LLC · Sheridan, WYBuilt 1978 · S/N 32R-7887010 N317GCGospel Carrier International Inc · North Potomac, MDBuilt 2000 · S/N 4636292 N317HABauer Aviation LLC · Saint Germain, WIBuilt 1977 · S/N 31-7812043 N317MSHolley Melissa T · Baton Rouge, LABuilt 2019 · S/N T20609563 N317PZFairmont State University · Fairmont, WVBuilt 1980 · S/N 27-8054047 N317SFLasher Patrick R · Magnolia, DES/N 31-7300912 N31847Nevada Air Partners LLC · Boulder City, NVS/N 32R-7887011 N318CWHeronimus Kevin A · Lebanon, TNBuilt 1998 · S/N 4636153 N318PKValiair Lc Trustee · Casper, WYBuilt 1978 · S/N 32R-7887037 N318RHN72jp Inc · Annandale, VABuilt 1976 · S/N 27-7654184 N318SPace Glen M · Columbia, MSS/N 76-32-164 N31920Sarasin Stuart P · Au Train, MIS/N 32R-7887015 N31932Air Cargo Solutions Inc · Two Rivers, AKBuilt 1973 · S/N 31-7405144 N31961Duncanson Scott Alexander · Grand Blanc, MIBuilt 1978 · S/N 32R-7887017 N31981Elusive Aviation Inc · Pflugerville, TXBuilt 1978 · S/N 32R-7887018 N31998Lance Group LLC · Moab, UTBuilt 1978 · S/N 32R-7887019 N319CSRas Airways LLC · Garland, TXBuilt 2016 · S/N T20609219 N319RDN319rd LLC · Casa Grande, AZBuilt 1998 · S/N 4636139 N319UWebb Automotive Group Inc · Farmington, NMBuilt 2015 · S/N 4636653 N31DGGrommeck Aviation LLC · Steamboat Springs, COBuilt 2024 · S/N T18209163 N31FBBreazeale Annette M · N Richlnd Hls, TXBuilt 2005 · S/N 3350 N31PRAlpha Whiskey 1 LLC · Brandon, MSBuilt 1979 · S/N 317952049 N31PWClark David L · Washoe Valley, NVBuilt 1968 · S/N 32-40510 N31RDIsland Bound LLC · Dunedin, FLS/N 31-7852059

Back to AD 71-13-01 R1