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.

N700GLPitcock Aviation LLC · Tompkinsville, KYBuilt 1967 · S/N 31-83 N700HWHotel Whiskey LLC · Sylvania, OHBuilt 1999 · S/N T20608034 N700KFTurbine Motor Conversions LLC · Orange, CABuilt 1984 · S/N H-10 N700LDNorthridge Consulting Enterprises LLC · Santa Clarita, CABuilt 1981 · S/N 62P-928-8165051 N700MFEtavan LLC · Satellite Beach, FLBuilt 1976 · S/N 61P-0282-064 N700VWCondor Aviation LLC · Bethlehem, PABuilt 1984 · S/N 60-8423012 N700WZPinto Robert · Sicklerville, NJBuilt 1984 · S/N 60-8423007 N700YWHorwath Ricky N · Saint James City, FLBuilt 1979 · S/N 70029 N7010FEconomou Michael · Falls Church, VAS/N 32R-7780051 N7016FNations One For Christ · Duluth, MNS/N 32R-7780052 N701DMPacific Fleet Aviation LLC · Rochester, NYBuilt 1966 · S/N 27-3131 N701JGAerostar LLC · Newport Beach, CABuilt 1969 · S/N 61-0034 N701YWHorwath Ricky N · St James City, FLBuilt 1979 · S/N 70031 N702PGOn Three Angels Wings LLC · Melbourne, FLBuilt 1984 · S/N 60-8423009 N70394Halford Richard W · Eagle River, AKS/N 18502147 N7039CJdk Aviation LLC · Kalispell, MTBuilt 1975 · S/N 32-7640041 N703CMSeneca Structural Engineering Inc · Irvine, CABuilt 2010 · S/N T20608965 N703CWWasem Investments LLC · Salem, ORBuilt 2005 · S/N T18208464 N703DPProfessional Aviation Group LLC · Wilmington, DES/N 27-3861 N703TBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2000 · S/N 2035 N703WMMoore Tom · Basalt, COBuilt 2005 · S/N T18208461 N7045GBig Rock Aviation LLC · Big Rock, ILBuilt 1976 · S/N 32R-7680272 N704MCCrowther Construction Inc · Pleasant View, UTBuilt 2004 · S/N T18208251 N7052HScruggs Ken · Galloway, OHBuilt 1975 · S/N 27-7554130 N70543Tk Group Holdings LLC · Wilmington, DEBuilt 1976 · S/N 31-7612029 N705JWTulare County Sheriff · Visalia, CABuilt 2004 · S/N T20608490 N705SFLet Industries LLC · Lewes, DEBuilt 1974 · S/N 27-7405311 N705TBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2005 · S/N 2215 N7069DSo Many Trees LLC · Hanover, NHBuilt 1978 · S/N 31-7812081 N706CGDonegal Excavating Inc · Lemont, ILBuilt 2016 · S/N 4636706 N706SPEastern Cincinnati Aviation Inc · Batavia, OHBuilt 1974 · S/N 27-7405394 N707DAProp Flying LLC · Missoula, MTBuilt 2007 · S/N T18208771 N707DPPlus2cmake9 LLC · Grant, ALBuilt 2008 · S/N T20608857 N707GZSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2013 · S/N 4636577 N707JPSierra Hotel Inc · Van Buren, ARS/N 60-8423018 N707VTPrecision Air Vt LLC · Las Vegas, NVBuilt 2004 · S/N T20608470 N70846Dc Aero LLC · Ramona, CABuilt 1971 · S/N 274593 N708THH & H Contractors · Leesburg, TXFirst renewal noticeBuilt 2005 · S/N T20608578 N709AMAirtrust LLC - 13 - Series 13 Trustee · Sheridan, WYBuilt 2001 · S/N 2101 N709CCTransport Partners LLC · Huntersville, NCBuilt 2008 · S/N 4692030 N709SAN709sa LLC · Maxville, FLBuilt 1983 · S/N 318352027 N70FLFl Jet Services Inc · Miami Springs, FLFirst renewal noticeBuilt 1978 · S/N 31-7952030 N70GGAnderson Gary · Port Orange, FLBuilt 2018 · S/N L2K-141 N70HHAmys Aircraft Services LLC · Bridgeton, MOBuilt 1974 · S/N 31-7405208 N70JMTriple M Investments LLC · Whitehall, PABuilt 1976 · S/N 32R-7680259 N70KCLa Chabola Aviation LLC · Plano, TXBuilt 1976 · S/N 61P-0291-070 N70TLAltitude Adjusters LLC · Cranford, NJBuilt 1965 · S/N 27-2797 N70ZRusyniak Anthony J · Syracuse, NYBuilt 1968 · S/N 31-357 N710BBGomez Juan Pablo · Mcallen, TXBuilt 2025 · S/N T20609828 N710BFConway Aviation LLC · Stewartville, MNBuilt 2024 · S/N T20609773

Back to AD 71-13-01 R1