Registered aircraft · 47,142

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.

N110CCIntermountain Aero Inc · Salt Lake City, UTBuilt 1966 · S/N D-8339 N110CSFlorida Keys Flight Academy LLC · Marathon, FLBuilt 1972 · S/N 310Q0616 N110CWMile High 1 LLC · Lakeway, TXBuilt 1980 · S/N TK-115 N110DKZeus Boulder Aviation LLC · Boulder, COBuilt 2025 · S/N 10414 N110FBElon Aviation LLC · Burlington, NCBuilt 1976 · S/N TC-2024 N110FLMac Air Aviation LLC · Xenia, OHBuilt 2007 · S/N 2813 N110FSMaggie L Air Service LLC · Kalispell, MTS/N 18256604 N110GBBaron North G58 LLC · Orchard Park, NYBuilt 2023 · S/N TH-2543 N110GGSkyview Aviation LLC · Tracy, CABuilt 2024 · S/N 3449486 N110GKJaws Aviation LLC · Ridgeland, MSBuilt 2017 · S/N 4508 N110HPColt 45 LLC · Tulsa, OKS/N 21059810 N110KMCars Planes And Land LLC · Fuquay Varina, NCBuilt 1983 · S/N 21064800 N110MEAce States Southwest LLC · Stanton, TXBuilt 1979 · S/N EA-17 N110MJTuggle Jason C · Liberty Hill, TXBuilt 1975 · S/N 34-7570117 N110MTMiddle Tennessee State University · Murfreesboro, TNBuilt 2025 · S/N 10677 N110MVHerring Creek Aviation LLC · Edgartown, MABuilt 2017 · S/N 1521 N110MXShoreline Flyer Corp · Kenosha, WIFirst renewal noticeBuilt 2011 · S/N 0096 N110NJState Of New Jersey · Trenton, NJBuilt 1986 · S/N U20606938 N110NPJungemann Jeff D · Brigham City, UTBuilt 1973 · S/N 33701565 N110PAPostupack Peter Jr · New Cumberland, PAS/N 25-2007 N110RLProctor Charles L · Alachua, FLBuilt 1973 · S/N P3370095 N110RVMillspaugh John · Weatherford, OKBuilt 1981 · S/N 34-8133196 N110SMPenhall Michael Joseph · Lake Forest, CABuilt 1964 · S/N 337-0023 N110TAHuntress Aviation LLC · Paradise Valley, AZS/N 2015 N110TKSchnorf Curt L · Centerview, MOS/N 18262939 N110USZwainz Thomas G · Reardan, WABuilt 1970 · S/N 18260234 N110VEHorizon Group Inc Trustee · Boca Raton, FLBuilt 1977 · S/N 414A-0017 N110VTFly N110vt LLC · Venetia, PABuilt 2020 · S/N 2151 N110WFValiair Limited Co Trustee · Casper, WYBuilt 2007 · S/N 2621 N110WKCirrus Design Corp · Duluth, MNBuilt 2011 · S/N 2115 N110YDLloyd Clee · Canby, ORBuilt 1975 · S/N 21060858 N1110CGriffith Danny E · Little Rock, ARS/N D-5117 N1110SMob Aviation USA LLC · Kissimmee, FLS/N 21061119 N1110VMagic Carpet 1 LLC · Overland Park, KSBuilt 2024 · S/N 10006 N1110WFoulks Alan Lee Trustee · Glendale, AZBuilt 1972 · S/N D-9310 N11114Daly Arthur P · El Paso, TXBuilt 1968 · S/N D-8901 N11118Aircraft Partner Holdings Inc Trustee · Fallbrook, CABuilt 1963 · S/N 18051230 N1111ZHamburger Ronald O · Terrebonne, ORBuilt 1960 · S/N CD-276 N1112JJedco Properties LLC · Ruston, LABuilt 1997 · S/N TH-1822 N1112LGunrunner 15 Air LLC · Hilton Head Island, SCBuilt 2009 · S/N 421017 N1112QLastowski Gerald J · Gulf Breeze, FLBuilt 1963 · S/N 310H0112 N1112TRegistration Pending · Soldotna, AKRegistration pendingBuilt 1964 · S/N 50713 N1113TWirthlin Donald K · Sierra Vista, AZBuilt 1957 · S/N 35561 N1113XRegistered aircraftBuilt 1997 · S/N TH-1813 N1114JWarren Shelburne Michael · Chattanooga, TNBuilt 1997 · S/N E-3072 N1114XAlyeska Aero LLC · Wilmington, DEBuilt 1996 · S/N E-3055 N1115ZBurks Rickey D · Boerne, TXBuilt 1996 · S/N E-3015 N1116AMaher Thomas J · Charlotte, NCBuilt 1997 · S/N E-3073 N1116TImg Management Services Corp · Wapwallopen, PABuilt 1968 · S/N TC-1127 N1116ZBear Harbor Aviation LLC · Polson, MTBuilt 1997 · S/N EA-596

Back to AD 2000-23-21