Registered aircraft · 47,138

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:2000-23-21') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21') 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:2000-23-21')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
  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:2000-23-21')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2000-23-21')
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.

N2606QElsayed Von Bayreuth Alaaeldeen Mohamed · Fairfield, CABuilt 1966 · S/N 18257806 N2606UJanovyak Aviation LLC · Lockport, ILBuilt 1979 · S/N 28R-7931291 N2606XSmith And Cherry Aviation LLC · Knoxville, TNBuilt 1965 · S/N P206-0106 N2607GJensen Rodney · Aptos, CABuilt 1959 · S/N 51907 N2607SHunter Gary A · Fort Wayne, INBuilt 1976 · S/N 21061338 N2607ZSidney Aviation LLC · Sidney, NEBuilt 1963 · S/N 185-0607 N2608QMiller David C · Burlington, CTBuilt 1966 · S/N 18257808 N2608RRegistered aircraftBuilt 1967 · S/N 18258308 N2608XOdonnell James E · Northport, NYBuilt 1965 · S/N P2060103 N2609QDawson Arden H III · Eagle Nest, NMBuilt 1966 · S/N 18257809 N2609YHelvey Michael H · Sheridan, WYBuilt 1962 · S/N 18051109 N260AACarpenter Timothy A · Phoenix, AZBuilt 1966 · S/N D-8325 N260ADAtwood Distributing Lp · Enid, OKBuilt 2013 · S/N E-4017 N260ARDeep South Flying Services LLC · Albany, GABuilt 1983 · S/N TJ436 N260ATAston William L II · Granbury, TXBuilt 2000 · S/N 30-0046 N260AVAlpha Victor LLC · Wilmington, DEBuilt 2018 · S/N 1677 N260DFMatchbox Holdings LLC · Harrisonburg, VABuilt 1975 · S/N 18264479 N260DHStephens Ryan J · Dallas, PABuilt 1987 · S/N 20 N260EABlue Sky Airfleet LLC · Kalispell, MTBuilt 2004 · S/N E-3408 N260KKingsboro Industrial Park LLC · Rocky Mount, NCBuilt 2012 · S/N TH-2331 N260MSmith David W · Milaca, MNS/N 298 N260MXValiair Lc Trustee · Casper, WYBuilt 2026 · S/N 11309 N260PTPeterson Todd · El Dorado, KSBuilt 1977 · S/N 18265612 N260SRCherry Ernest M Jr · Venice, FLBuilt 2007 · S/N 2570 N260STPitts S2b LLC · Salinas, CABuilt 1981 · S/N 34-8133047 N260TGPickerel Enterprises LLC · Bennet, NES/N 18267521 N2610Avionicos Corp · Nokomis, FLBuilt 1977 · S/N 34-7770428 N2610CNelson Scott J · Saline, MIBuilt 1954 · S/N 35010 N2610GBas Part Sales LLC · Greeley, COBuilt 1979 · S/N 402C0064 N2610SGordon Daryl B · Bellevue, WABuilt 1968 · S/N 337-0910 N2611FMccall Aviation LLC · Union Springs, ALBuilt 1965 · S/N 18256711 N2611MOlsen Robert F · Chatham, MABuilt 1977 · S/N 28R-7803138 N2611XHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0072 N2612QLabarre Ben A · Hayward, WIS/N 18257812 N2612SNixon Edward J · Collierville, TNS/N 337-0912 N2612XMcnutt Brian K · Dillon, MTBuilt 1965 · S/N P206-0112 N2613CThree Two Five Echo Fc · Corinth, TXBuilt 1985 · S/N E-2293 N2613FHowe Justin · Encampment, WYBuilt 1965 · S/N 18256713 N2613SLow Wing Aviation LLC · Mountain Home, ARBuilt 1976 · S/N 21061340 N2614FWissenbach Richard G · Pinesdale, MTBuilt 1965 · S/N 18256714 N2614LCharter Flights Caribbean Inc · San Juan, PRBuilt 1979 · S/N 402C0092 N2614QBeyers Donald · Pana, ILBuilt 1966 · S/N 18257814 N2614RWindh Steven R · Reedley, CAS/N 18258314 N26156Hyannis Air Service Inc · Hyannis, MABuilt 1979 · S/N 402C0112 N2615GHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0101 N2615QVenture Air Solutions Inc · Opa Locka, FLBuilt 1980 · S/N 402C-0321 N2615RWolf Coy D · Ord, NEBuilt 1967 · S/N 18258315 N2615ZCalhoon John Charles · Woodinville, WABuilt 1999 · S/N 2050036 N2616FNotziger Shawn M · Lilburn, GABuilt 1965 · S/N 18256716 N2616QSutton Marshall T · Erick, OKBuilt 1966 · S/N 18257816

Back to AD 2000-23-21