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.

N337BMorris Robert D · Laughlin, NVBuilt 1967 · S/N 337-0775N337BBLewis University · Romeoville, ILBuilt 1969 · S/N 33701194N337BDSouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 1973 · S/N 0062N337BNDestiny Center Inc · Murfreesboro, TNBuilt 1972 · S/N 33701449N337BTKrall Jeff · Mitchell, SDBuilt 1969 · S/N 33701223N337CBarney Julius C · Lutz, FLBuilt 1968 · S/N 337-0905N337CDKeller Stephen P · Wichita, KSBuilt 1973 · S/N 33701495N337CEBeam David M · Sabina, OHBuilt 1976 · S/N 33701762N337CGH&J Flight One LLC · Sun City West, AZBuilt 1973 · S/N P3370143N337CHAviation Specialty Services LLC · Beaufort, NCBuilt 1977 · S/N 33701836N337DTomalar Inc · Vero Beach, FLNon-citizen corporation, flight hours not reportedBuilt 1966 · S/N 337-0306N337DEAirbermz LLC · Bloomfield Hills, MIBuilt 1980 · S/N 33701943N337DMMcwhorter Michael S · Fortuna, CABuilt 1968 · S/N P206-0471N337DWR And R Aircraft Inc · Delray Beach, FLBuilt 1975 · S/N 33701652N337EEAmpaire Inc · Long Beach, CABuilt 1974 · S/N 33701600N337EWWilson Cecil · Lithonia, GABuilt 1969 · S/N 337-1193N337FRomain Dennis · Payson, AZBuilt 1973 · S/N 33701547N337FMBrous James T Trustee · New York, NYBuilt 1997 · S/N 3449028N337FTMclenaghan Alvin N · Phoenix, AZBuilt 1966 · S/N 3370384N337GDPorrima Photonix Inc · Las Cruces, NMBuilt 1979 · S/N 33701921N337GGInterventional Cardiovascular Group Of San Juan In · Laredo, TXS/N 33701429N337GHInternational Air Services Inc Trustee · Carson City, NVBuilt 1973 · S/N FP3370007N337GMRegal Air Partners Sr22t LLC · New Iberia, LABuilt 2026 · S/N 11185N337GRLor Aviation LLC · Atlanta, GABuilt 1969 · S/N 33701210N337GSJc Holding LLC · Wilmington, DEBuilt 1973 · S/N 33701520N337GVVenturino Lee Angelo Trustee · Kure Beach, NCBuilt 2013 · S/N 3928N337HSCatering Of Central Texas Inc · Kerrville, TXBuilt 1984 · S/N 25-0834N337JJJodice Timothy · Amherst, NHBuilt 1972 · S/N P3370026N337JLDavis Mike D · Huntersville, NCS/N 337-0708N337JRInternational Air Services Inc Trustee · Carson City, NVS/N 33701474N337JSI V S K LLC · Wilmington, DES/N 337-1136N337KErwin Richard L · Killen, ALBuilt 1976 · S/N 0017N337KHValiair Lc Owner Trustee · Casper, WYBuilt 1977 · S/N FP 337 0020N337KTSky West Aviation Inc Trustee · Albuquerque, NMS/N FP3370014N337LASturgeon Kenneth V · Winter Garden, FLBuilt 1965 · S/N 337-0134N337LFA To B Flying Inc · Litchfield, ILFirst renewal noticeBuilt 1969 · S/N 337-1057N337LPSkymaster Stc LLC · Mena, ARBuilt 1977 · S/N 33701750N337MMAugugliaro Robert J · Albuquerque, NMBuilt 1967 · S/N 337-0608N337MWMtw Aerospace Inc · Montgomery, ALBuilt 1972 · S/N P3370021N337NEAviation Specialty Services LLC · Beaufort, NCBuilt 1969 · S/N 337-0997N337PHayes James J · San Diego, CAS/N 33701535N337PCPhantom Technologies LLC · Garden City, IDBuilt 1980 · S/N 21064212N337PPStreeter Adam W · Grand Prairie, TXBuilt 1979 · S/N 25-0030N337RTillman Tracy S · Webberville, MIBuilt 1977 · S/N P3370282N337RBAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 0869N337RCN337rc Corp Trustee · Wilmington, DEBuilt 1968 · S/N 337-1014N337RDDamschroder Rex A · Fremont, OHBuilt 1968 · S/N 337-0847N337RGStephens Kenneth Joe · Bristol, TNBuilt 1972 · S/N P3370067N337RJWilson Scott · Sheridan, WYBuilt 1975 · S/N 34-7570267N337RRLara Oscar · Bonita, CABuilt 1973 · S/N P3370116
Back to AD 2000-23-21