OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,133

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.

N34GCPhillips Stuart G · Woodside, CABuilt 1982 · S/N EA-283N34GTKawolis Paul F · Sutton, MAS/N G-697N34HEHaltitude Aviation LLC · Colorado Springs, COBuilt 1956 · S/N BG-165N34JPDakota Aircraft Inc · Pierre, SDBuilt 1973 · S/N CJ-39N34JSJ & K Aviation LLC · Bristow, OKBuilt 1976 · S/N 18264675N34JWRounds Donald C · Waller, TXS/N BG374N34KCh Aviation LLC · Wilmington, DEBuilt 1981 · S/N 18504349N34KBReilly Donald H · Micco, FLBuilt 1978 · S/N 21062656N34KFRsb Properties LLC · Lewes, DES/N P21000700N34KGEldon Jensen Funeral Properties Inc · Lemmon, SDBuilt 1983 · S/N 34-8333059N34KJWright Wing Aviation LLC · Pittsboro, NCBuilt 1961 · S/N G-715N34KMBravo Adventures LLC · Scottsdale, AZBuilt 1981 · S/N EA-207N34KRH & H Air Inc · Washington, INBuilt 1956 · S/N G-766N34LMNorfolknway LLC · Mount Pleasant, SCS/N 34-7770133N34LWAnderson Glenn L · Sandia Park, NMBuilt 1956 · S/N BG-160N34MESwift Ascent LLC · Dover, DEBuilt 2009 · S/N 31-0124N34MKBadger Industries LLC · Harvard, ILBuilt 1953 · S/N G-88N34MMSchubee Air Inc · Watkins, COBuilt 1967 · S/N 401-0125N34MPValiair Limited Co Trustee · Casper, WYBuilt 1998 · S/N 25-2028N34MRN34mr LLC · Orlando, FLBuilt 1952 · S/N G-39N34MTPerigee Investments LLC · Anacortes, WAS/N BG-417N34MXEwald Robert H · Red Lodge, MTBuilt 1984 · S/N PG-114N34NCSpencer Coastal Air LLC · Ellsworth, MEBuilt 1979 · S/N 18503886N34NYKeys Robert · Menifee, CABuilt 1973 · S/N 340-0196N34PACosentino William D · Lees Summit, MOBuilt 1955 · S/N G-268N34RInfinity Welding And Fabrication LLC · Celina, TXBuilt 2002 · S/N L2K-174N34RXNelson Miguel E · Lake Stevens, WABuilt 1946 · S/N 47N34SCTbhb Logistics LLC · Amarillo, TXBuilt 1978 · S/N TH-943N34SRL-Bird LLC · Hood River, ORBuilt 1963 · S/N 18255005N34SYGeneral Aviation Modifications Inc · Ada, OKBuilt 1956 · S/N BG-246N34TGTri W Inc · Shepherd, MTBuilt 2002 · S/N 0386N34TLAmeagle Aviation LLC · Coventry, CTBuilt 1977 · S/N 340A0423N34TNCirrus Sr22t 10713 Inc Owner Trustee · Wilmington, DEBuilt 2025 · S/N 10713N34TXMccormack Robert · Reno, NVS/N G-796N34UAInternational Air Services Inc Trustee · Carson City, NVS/N D-7241N34VBBarrett Victor L · Sevierville, TNS/N BG-361N34VFRomag Air Services Inc · Mc Lean, VAFirst renewal noticeBuilt 1979 · S/N P21000307N34VMRoberts Glenn T · Port Orange, FLBuilt 1954 · S/N G-98N34VVWattum Investments LLC · Kodiak, AKBuilt 1961 · S/N 185-0036N34VWGalloway Chris · Jordan Valley, ORS/N G-80N34VYTrident Aircraft Inc · Easton, MDBuilt 1955 · S/N BG-41N34WEWildes Thomas O · Chippewa Falls, WIBuilt 1979 · S/N 310R1597N34WGWings Of Grace Inc · Vonore, TNBuilt 2004 · S/N 0824N34WWChute Aviation LLC · Prescott, AZBuilt 1973 · S/N 340-0258N34XAVectored Solutions Inc · Everett, WABuilt 1945 · S/N G-799N34XDAnderson Aviation Inc · Anderson, SCBuilt 1952 · S/N G-25N34XXBallance Harry Greene Jr · Atlanta, GAS/N BG-54N34YKHood Frank A · Burlington, NCBuilt 1956 · S/N 144000N34ZXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1997 · S/N 3449010N3500YTuff Aviation LLC · Belmont, MIS/N 18262195
Back to AD 2000-23-21