Registered aircraft · 68,375

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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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:90-04-06-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.

N2757MHaring Clay · Lincoln, KSBuilt 1946 · S/N 121238 N2757VRasnake Larry J · Charlotte, NCBuilt 1975 · S/N 177RG0683 N2757WDennis Christopher A · Richardson, TXBuilt 1966 · S/N 1049 N2758Panair Flying Club Inc · Miami, FLBuilt 1975 · S/N 17265168 N2758MHaring Clay · Lincoln, KSBuilt 1946 · S/N 12-1154 N2758VRichey Reginald Wade · Lincoln, NMBuilt 1975 · S/N 177RG0684 N2759ARichards Thomas D · Saint Jo, TXBuilt 1946 · S/N 7AC-6389 N2759PWilkinson Kevin · Alliance, NES/N 22-3067 N2759RFord William(Bill) A III · Abilene, TXBuilt 1969 · S/N 28R-35284 N2759VRedwing Aviation LLC · San Antonio, TXBuilt 1975 · S/N 177RG0685 N2759WBar F Aviation LLC · Scottsbluff, NES/N 3352 N275ACTsutsumi Erika E · Boston, MABuilt 1998 · S/N 1372-98 N275AMAerodynamic LLC · Aurora, ORBuilt 2022 · S/N 2881518 N275CBCalifornia Baptist University · Riverside, CABuilt 2025 · S/N 2881916 N275CCSellers Richard V · Byron, CABuilt 2001 · S/N 9922CC N275CWLunde Craig W · Fort Shaw, MTBuilt 1946 · S/N 1744 N275DBKrejci Ryan J · Sandstone, MNBuilt 1988 · S/N 275 N275DFAspen Ring LLC · Bloomington, INS/N 2518 N275DSMebane Alfred Holt IV Trustee · San Diego, CABuilt 2003 · S/N 40.275 N275FAFly Gateway Aviation Institute · New Castle, DEBuilt 2022 · S/N 28020058 N275GTPs N275gt LLC · Green Bay, WIBuilt 1978 · S/N 17271631 N275JKKrol Jeffrey P · Somers, CTBuilt 1969 · S/N 28-26151 N275MAFranzoy Steve · Salem, NMS/N 1014-2006 N275NDPlane Nonsense · Middletown, DEBuilt 2000 · S/N 2842097 N275RVMccutchan Philip · Mount Vernon, INBuilt 2006 · S/N 80275 N27601Elkins Dennis E · Erie, COBuilt 2004 · S/N 6-3887 HDS N2760PDickerson Gary M · Homer, AKBuilt 1955 · S/N 22-3070 N2760VFinish Line - N2760v LLC · Edmond, OKS/N 177RG0686 N2760WHardin Robert S · Renton, WABuilt 1966 · S/N 1050 N2760YSanders Flight Training Inc · Jasper, ALBuilt 1958 · S/N TD-126 N2761PCarlin Thomas J · N Richland Hills, TXBuilt 1955 · S/N 22-3071 N2762MRaymond Mark A · East Jordan, MIBuilt 1946 · S/N 12-1158 N2762WRouth Frank D · Marion, NCBuilt 1966 · S/N 1052 N2762YFisher Global LLC · Conway, ARBuilt 1958 · S/N TD-129 N27632Mason Mark W · Pleasant Prairie, WIBuilt 1940 · S/N 2274 N27639Kiehl Timothy A · Glendale, AZBuilt 1940 · S/N 2281 N2763GWilko Air LLC · Van Wert, OHBuilt 1967 · S/N 459 N2764PBrine William R · Pahrump, NVS/N 22-3075 N2764YChennault Flying Services LLC · North Las Vegas, NVBuilt 1958 · S/N TD-128 N27652Bilstad Jacob A · Plano, TXBuilt 1940 · S/N 2294 N27657Braness Jim G · Richmond, MNBuilt 1940 · S/N 2299 N2765MExperimental Aircraft Association Chapter 1218 · Willow Springs, MOBuilt 1946 · S/N 12-1167 N2765QHoney B LLC · Hillsboro, ORS/N 28-7716121 N2765WBriseno Anthony · Virginia Beach, VABuilt 1966 · S/N 1168 N2766MDahl Jerome M · Iron River, MIBuilt 1977 · S/N 28-7816309 N2766PMarti Larry B · Rolla, MOS/N 22-3077 N27671Clearwater Air & Auto Museum · Batavia, OHS/N 2313 N2767MNew Ulm Flight Services LLC · Marshall, MNBuilt 1977 · S/N 28-7890266 N2767PMatta Sam · Brookshire, TXBuilt 1976 · S/N 255-76 N2767SLarsen Mark A · Carmel Valley, CABuilt 2003 · S/N 9126-A-1092 BB

Back to AD 90-04-06 R1