OpenAirDocs.org
AD 2000-23-21

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
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.

N19EZAir Mobile Ministries · Sneedville, TNBuilt 1970 · S/N 33701315N19FABrown Brian T · Wilton, CABuilt 1961 · S/N 18253809N19FBWojnicki Chester · Mt Prospect, ILBuilt 1976 · S/N 21061668N19FGAchtel Stephen E · Delavan, WIBuilt 1972 · S/N 139N19GCarlton Steve W · Lewiston, IDBuilt 1963 · S/N 18254596N19GCKobaly Jason D · Yucca Valley, CABuilt 1972 · S/N 18261280N19GHOscar Deuce LLC · Virginia Beach, VABuilt 1967 · S/N 67-21374N19JFinch Lee · Lakeway, TXBuilt 1964 · S/N 22741N19JMTlc Car Wash Land Trust Corp · Homosassa, FLS/N 3382N19KEPopcorn In The Clouds LLC · Farmington, NMBuilt 2020 · S/N 2194N19KYChi Yang · Lafayette, COS/N TE-1073N19LBSanders Brian L · Tehachapi, CABuilt 1982 · S/N 21064705N19LDDanper Inc · Livingston, MTBuilt 1951 · S/N 22768N19LFN19lf Corp · Oak Lawn, ILBuilt 1972 · S/N 310Q0622N19LJSr22t LLC · Chattanooga, TNBuilt 2023 · S/N 9116N19LLDsr-Cherokee 180 LLC · Dallas, TXBuilt 1970 · S/N E-224N19LPZelta LLC · Wilmington, DEBuilt 2016 · S/N TH-2473N19LVLeon Ruben D · Oviedo, FLBuilt 1972 · S/N P3370012N19MAAvco Security Systems Inc · Jupiter, FLBuilt 1966 · S/N D-8173N19MBDg Aircraft LLC · Lemont Furnace, PAS/N 34-7970031N19MJCivil Air Patrol Inc · Maxwell Afb, ALBuilt 1979 · S/N U20605372N19MNShields Charles F · Gilberts, ILBuilt 1978 · S/N E-1347N19MTDaviation Inc · Willoughby, OHBuilt 1976 · S/N E798N19PLively Gregory · Corinth, TXBuilt 1969 · S/N 337-1091N19PAAkradi Parviz Trustee · Laguna Niguel, CABuilt 1977 · S/N 28R-7803129N19PMFlying Turtle LLC · Carmel, INBuilt 2022 · S/N 9027N19QTInternational Aviation Group LLC · Lake Wales, FLBuilt 2003 · S/N 0593N19RAAviatzone LLC · Fort Lauderdale, FLS/N TK-44N19REEtcheverry Ray L · Bakersfield, CABuilt 1970 · S/N CE-299N19RFLynn Air Flying Club Inc · Woodinville, WABuilt 1974 · S/N E-627N19RMRmaction Inc · Stevenson Ranch, CABuilt 2007 · S/N 2631N19RSCarillon Corp · Panama City, FLBuilt 2013 · S/N T24002018N19RWSkyrider Aviation LLC · Wilmington, DEBuilt 2022 · S/N 8656N19SASierra Aviation LLC · Hendersonville, TNBuilt 1980 · S/N E-1795N19SBMcginnis Randall E · Redding, CABuilt 1972 · S/N P3370018N19SKEagle Capital Holdings LLC · Doylestown, PABuilt 2025 · S/N 10862N19SLMifflin Enterprises LLC · Mansfield, OHBuilt 1976 · S/N D-9848N19SYRanalli Douglas J · Naples, FLBuilt 2022 · S/N 8858N19TLHall Kurt D · Fort Lauderdale, FLBuilt 1975 · S/N U20602629N19TPTwv Air LLC · Ewing, NJBuilt 1978 · S/N 34-7870383N19TRCoda Aviation LLC · Athens, TXBuilt 2018 · S/N 4601N19TWDougherty Peter I · Orchard Park, NYBuilt 1953 · S/N 30119N19WCV35a LLC · Beacon, NYBuilt 1969 · S/N D-8998N19WERlv Industries Inc · Westerly, RIBuilt 1997 · S/N 3449037N19XPGraves John Michael · Memphis, TNBuilt 2014 · S/N 001N19YLegacy Air Holdings LLC · Helena, MTBuilt 2003 · S/N L2K-193N1AVLeader Nicholas A · Billings, MTBuilt 1962 · S/N TC-366N1AWKoedam Robert E · Saint Louis, MOBuilt 1960 · S/N D-6617N1AYRoyal Aviation LLC · Hendersonville, TNBuilt 2021 · S/N 5031N1BDFloyds Aero Inc · Amarillo, TXS/N G-91
Back to AD 2000-23-21