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.

N2616SMontana Alpha Omega Ranch LLC · Miles City, MTBuilt 1976 · S/N 21061342N2617GGandiaga Philip J · Buhl, IDBuilt 1959 · S/N 51917N2617RFener Seth M · Claremont, CABuilt 1967 · S/N 18258317N2617SPlummer Kenneth W · Sullivan, INBuilt 1968 · S/N 337-0917N2617X2gl P&I LLC · El Paso, TXBuilt 1965 · S/N P206-0117N2618CCampbell Terence · Zanesville, OHBuilt 2022 · S/N 8942N2618GEagle Mountain International Church Inc · Newark, TXBuilt 1959 · S/N 51918N2618LFl & J Air Corp · West Orange, NJBuilt 1979 · S/N 414A0284N2618MSoltis Stephen T · Kingsport, TNBuilt 1977 · S/N 34-7870089N2618RMelton Edward A · Glendale, AZBuilt 1967 · S/N 18258318N2618SOldham Richard · Quartzsite, AZBuilt 1968 · S/N 337-0918N26195Bradley Mark R · Brush Prairie, WABuilt 1959 · S/N 50492N2619FHayes Barrett W · Siler City, NCBuilt 1965 · S/N 18256719N2619GDodson International Parts Inc · Rantoul, KSFirst renewal noticeS/N 414A0290N2619LAircraft Holding Solutions LLC Trustee · Newark, DEBuilt 1979 · S/N 414A0291N2619QHoman Edward L · Cincinnati, OHBuilt 1967 · S/N 18257819N2619RRickert & Son LLC · Moses Lake, WAS/N 18258319N2619XBrume Shawn O · Fairbanks, AKBuilt 1965 · S/N P206-0119N2619Z4j Air LLC · Cartersville, GABuilt 1979 · S/N 414A0293N261AARoy Michael W · Pear Valley, TXBuilt 1959 · S/N D-5855N261ALCkm Aircraft Holdings I LLC · Mandan, NDBuilt 1978 · S/N 414A0207N261ATDmm Aviation 1 LLC · Kingsburg, CABuilt 2023 · S/N 9037N261CBGober Charles K · Sand Springs, OKBuilt 1980 · S/N 25-0391N261CDQualitair LLC Trustee · MichelstadtBuilt 2002 · S/N 1182N261DBKhamer Laasn LLC · Longmont, COBuilt 1986 · S/N 25-1083N261DRSafeflite Aviation LLC · Glenwood, IAS/N 31114N261EABrownstone Aviation II LLC · Houston, TXBuilt 2001 · S/N E-3423N261EMJeffrey Brian Cooper · Poway, CAS/N 18260587N261FEdwards Robert J · Saint Helena, CABuilt 2025 · S/N 10718N261GVBohn Jim A · Mead, WAS/N 18253174N261JMHundal Medical Corp · Malibu, CABuilt 2007 · S/N 29-0475N261LABrown Jeffrey L · Mint Hill, NCBuilt 1979 · S/N 25-0275N261MCPisciotta Matteo R · Fort Collins, COBuilt 2018 · S/N 1753N261MJCma Sr22 Inc Trustee · Wilmington, DEBuilt 2022 · S/N 8597N261RTjarks Edward F · Mesa, AZBuilt 1980 · S/N 25-0392N261REPeterson Randy J · Sonoma, CAS/N 35284N261RJJaycobs Richard · Siasconset, MABuilt 1983 · S/N 25-0749N261SBird Frank III · Jennings, FLBuilt 1965 · S/N 65-12696N261SSScopellite Sebastian · Phoenix, AZS/N 18261130N261TAMiller Shawn M · Canovanas, PRS/N 25-0340N261TGCirrus Digital LLC · Asheville, NCBuilt 1983 · S/N 250757N261WTCvd Recreation LLC · Saint Charles, MOBuilt 2023 · S/N 9440N262Run For The Hills LLC · Kalispell, MTBuilt 1975 · S/N P3370217N2620FWood Don B · Centerville, UTBuilt 1965 · S/N 18256720N2620GBas Part Sales LLC · Greeley, COS/N 51920N2620QAkroyd Robert F Jr · Raton, NMBuilt 1967 · S/N 18257820N2621FGallaher Boyd H · Prescott, AZBuilt 1965 · S/N 18256721N2621GAdamic David J · Cedar Hills, UTBuilt 1959 · S/N 51921N2622FFlying Wolves Inc · Arnegard, NDBuilt 1965 · S/N 18256722N2622GKaplan Steven M · North Monmouth, MES/N 51922
Back to AD 2000-23-21