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.

N266KPN266kp LLC · Cincinnati, OHBuilt 2023 · S/N 9386 N266PDLiberty Garden Center Inc · Norwich, NYBuilt 1967 · S/N D-8654 N266RSAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2006 · S/N 1703 N266RVHuelskamp Thomas L · Fowler, KSBuilt 2009 · S/N 22480 N266SRRf Aviation LLC · Eaton, COBuilt 2007 · S/N 2626 N266TCAir Control Systems · Bigfork, MTS/N EA-483 N266UKAltitude Assets LLC · Palo Alto, CABuilt 2025 · S/N 10491 N2670MPhelan Construction LLC · North Andover, MABuilt 1986 · S/N CE-1082 N2670YErickson Wesley B · Littleton, COBuilt 1962 · S/N 18051170 N2671CHouchen Chris F · Palmer, AKBuilt 1955 · S/N 35071 N2671RCw Equipment Rentals Inc · Biggs, CABuilt 1967 · S/N 18258371 N2672CClipper Sky LLC · Las Vegas, NVS/N 35072 N2672GPhillips Douglas S · Gloversville, NYBuilt 1959 · S/N 51972 N2672MSchmoll Aviation LLC · Sterling, AKBuilt 1966 · S/N 18051729 N2672SJja Transportation LLC · Springville, UTBuilt 1968 · S/N 337-0972 N2672YSchmieding Michael · Salem, ORBuilt 1962 · S/N 18051172 N26732Jefferies Jon F · Elk Grove Village, ILBuilt 1990 · S/N 90-301012 N2673BM & N Of Alabama LLC · Magnolia Springs, ALBuilt 1980 · S/N 414A0630 N2673DAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1979 · S/N 340A0755 N2673GChapman Chad · San Antonio, TXBuilt 1959 · S/N 51973 N2673RDouville Laura Deluea · Portland, ORBuilt 1967 · S/N 18258373 N2673SWilliams Randall S · Chico, CABuilt 1976 · S/N 21061348 N2673ZFiske James K · North Andover, MABuilt 1963 · S/N 185-0673 N2674CTri County Sprayers Inc · Hamlin, TXBuilt 1955 · S/N 35074 N2674XKaiser Eric J · Milford, INBuilt 1966 · S/N P206-0174 N2675FVarnado Matthew G · Denham Springs, LABuilt 1965 · S/N 18256775 N2676BKero Jet Corporation · Montgomery, TXBuilt 1979 · S/N 340A0762 N2676GHolland Ross D · Guymon, OKBuilt 1959 · S/N 51976 N2676KFurey Michael J · Hazlehurst, MSS/N 18053033 N2676RStauter Michael D · Idabel, OKBuilt 1979 · S/N 340A0765 N2676YHands Holdings · Newark, DEBuilt 1981 · S/N 414A0631 N2677FNeu Aviation LLC · Benton, LABuilt 1965 · S/N 18256777 N2677GPeterson Barbara A · Cheney, KSBuilt 1959 · S/N 51977 N2677KAeropod Inc · Aurora, COS/N 18053034 N2677ST&D Janitorial Services LLC · Dexter, MOBuilt 1988 · S/N 89-301003 N2677XHawk Jeff · Flowermound, TXBuilt 1965 · S/N P206-0177 N2677YHracha Deanna L · Palmer, AKBuilt 1963 · S/N 18051177 N2678SHardy Mikel Gareth · Thatcher, AZBuilt 1973 · S/N 18502265 N2678XStewart Jeffrey D · Snyder, TXBuilt 1965 · S/N P206-0178 N2678ZKing Canyon Buffalo Inc · Denver, COFirst renewal noticeBuilt 1990 · S/N 90-301010 N26795Horan Roger · Plainview, TXBuilt 1992 · S/N 93-301015 N2679FR & K Explorations Inc · Bonners Ferry, IDBuilt 1966 · S/N 18256779 N2679RSchultz Charles D · Webster, WIBuilt 1967 · S/N 18258379 N2679SJordan Richard L · Memphis, TNBuilt 1968 · S/N 337-0979 N2679ZRonalter John M · Norristown, PABuilt 1963 · S/N 185-0679 N267CAHyannis Air Service Inc DBA · Hyannis, MABuilt 1979 · S/N 402C0030 N267CDTsp Aviation LLC · North Fort Myers, FLBuilt 2003 · S/N 1284 N267CPVanesian Bryan Dean · Apple Valley, CABuilt 2008 · S/N 3047 N267CTBachlechner Thomas Christian · San Diego, CABuilt 2007 · S/N 31-0050 N267DSRc Aviation LLC · Pikeville, KYBuilt 2006 · S/N 1667

Back to AD 2000-23-21