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.

N3166FShelton K Trustee · Perrysburg, OHBuilt 1966 · S/N 18257266 N3166RVarnson Dale B · Brocket, NDBuilt 1967 · S/N 18258566 N3167DOrtlip Stephen A · Kenbridge, VABuilt 1955 · S/N 31965 N3167FGreen James C · Cedar Rapids, IABuilt 1966 · S/N 18257267 N3167SLightning Bolt Aviation LLC · Bozeman, MTS/N 18255667 N3168CRegistration Pending · Anchorage, AKRegistration pendingS/N 30967 N3168DBovee John W Or · San Diego, CABuilt 1955 · S/N 31966 N3168PMaxwell Aviation Holdings LLC · Kalispell, MTBuilt 1987 · S/N CE-1104 N3168RRunck Russell E · Watertown, MNBuilt 1967 · S/N 18258568 N3168WBlack Gold Flying Club Inc · Belvidere, NJBuilt 1974 · S/N E-510 N3168YSkydive Central New York LLC · Weedsport, NYBuilt 1962 · S/N 18254168 N3169LPhillips James A · Burlington, WIFirst renewal noticeBuilt 1965 · S/N 310J0169 N3169WCoelho Enterprises Inc · Dayton, NVBuilt 1974 · S/N E-512 N316ABRegistered aircraftBuilt 2006 · S/N 2079 N316BCBc Air LLC · Great Falls, VABuilt 2024 · S/N 10358 N316BW345ds Capital Holdings LLC · Scottsdale, AZBuilt 2025 · S/N 11104 N316CDRegistration Pending · Fort Worth, TXRegistration pendingS/N 0876 N316DFThacker Orbie A · Wellington, ALFirst renewal noticeBuilt 1997 · S/N TH-1817 N316DRKrehko Industries LLC · Gillette, WYBuilt 2008 · S/N 1014 N316DSJensen Jared · Richfield, UTBuilt 1966 · S/N CE-98 N316HJHiester Aviation LLC · Fuquay Varina, NCBuilt 2021 · S/N 2358 N316JGKoch Eric R · Jasper, TXBuilt 1982 · S/N E-2038 N316JSRegistration Pending · Bluffton, SCRegistration pending, canceledBuilt 2019 · S/N 4814 N316KDRcjh7 LLC · St Louis, MOBuilt 2025 · S/N 10513 N316LRLake Wendell · Madison, WIBuilt 2004 · S/N 0841 N316LSC M & N D Inc · Wilmington, DEBuilt 1964 · S/N 18255604 N316MEHyperspeed Aviation LLC · Auburn, CABuilt 2020 · S/N 2204 N316MLJump N316ml LLC · East Berlin, PABuilt 1969 · S/N P2060549 N316PAkin Products Inc · Monticello, ARBuilt 1999 · S/N E-3237 N316PBDavison David D · Ponte Vedra, FLBuilt 2016 · S/N E-4088 N316PHMoon Hill Farm LLC · Kirkland, WABuilt 2004 · S/N 0891 N316PRN316pr LLC · Wilmington, DEBuilt 2014 · S/N 0852 N316RALeading Edge Flight Services Inc · Hampshire, ILBuilt 1974 · S/N 310Q1100 N316RJAction Helicopters Services Inc · Rockland, DEBuilt 2025 · S/N 10647 N316RWFour States Tire & Service Inc · Cortez, COBuilt 1979 · S/N 21063447 N316SFDoc Aviation LLC · Ponca City, OKBuilt 1964 · S/N 18255668 N316SSSkyhawk Leasing LLC · Indianapolis, INBuilt 2025 · S/N 11091 N316STBig Daddys Casinos Inc · Huntington, WVBuilt 2015 · S/N E-4078 N316TMCirrus Unlimited LLC · Alexandria, VABuilt 2011 · S/N 0117 N316TNBfo Inc Trustee · Wilmington, DEBuilt 2007 · S/N 31-0013 N316TSSb Ag Inc · Lodi, CABuilt 2019 · S/N 1906 N316WTSpatz Tony William DBA · Tulsa, OKBuilt 2021 · S/N 2303 N31707Bankruptcy Services LLC · Wilmington, DEFirst renewal noticeBuilt 1988 · S/N CE-1287 N31708Albatross Air Inc · Beaver, WVS/N EA-486 N3170FO'Neill Matthew · Indianapolis, INBuilt 1988 · S/N E-2407 N3170QRenfrow Denny · Kelseyville, CABuilt 1967 · S/N 18258170 N3170UHarrison Brian C · New London, OHBuilt 1962 · S/N 18254570 N3170YStillson John L · Rock Rapids, IAS/N 18254170 N3171Derr Matthew R · Frackville, PABuilt 1960 · S/N 39205 N3171CLand Sea & Air Inc · North Mankato, MNBuilt 1954 · S/N 30970

Back to AD 2000-23-21