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.

N1970SKeith Gregory A · Dade City, FLBuilt 1969 · S/N TC-1302N1970XJohnson Christopher S · Portland, ORBuilt 1965 · S/N 18256070N1970ZDash City Aviation LLC · Winston Salem, NCBuilt 1969 · S/N CD-1235N1971CAndrews Aviation LLC · Columbia, MOBuilt 2024 · S/N 10363N1971VThompson Timothy · Prosser, WAS/N 30395N1971XHigh Country Air Service LLC · Albuquerque, NMBuilt 1965 · S/N 18256071N1972USparrow Thomas E · Hawley, MNBuilt 1970 · S/N 18501702N1973Registered aircraftBuilt 1972 · S/N TE-886N1973JMormile Jason B · Fultonville, NYBuilt 1973 · S/N 18262469N1973USilver Fox Aviation LLC · Bay City, MIBuilt 1974 · S/N U20602316N1973XSuttle Joseph Scott · Moody, ALBuilt 1965 · S/N 18256073N1974DN822js LLC · Norcross, GABuilt 1973 · S/N E-493N1974GAirmax LLC · London, KYS/N 1297N1975Henay Air LLC · Windermere, FLBuilt 2021 · S/N 2375N1975ADayspring Aviation LLC · Bend, ORBuilt 1976 · S/N E-860N1975KFly By Night Management LLC · Downers Grove, ILBuilt 1974 · S/N D-9715N1975PBarry Aviation LLC · Boise, IDBuilt 2022 · S/N 9016N1975XFirefly Aviation LLC · Apison, TNBuilt 1965 · S/N 18256075N1976MJackling Eric S · Rochester, NYS/N 182-64331N1976XGmss LLC · San Diego, CABuilt 1965 · S/N 18256076N1977UErsland Nile P · Anchorage, AKBuilt 1970 · S/N 18501715N1977XOne Pft LLC · Denton, MTBuilt 1977 · S/N 18503405N1978FLofty Pursuits LLC · Sacramento, CABuilt 1981 · S/N P21000711N1978RJ Martin Auctions LLC · Waterloo, NYBuilt 2023 · S/N 9327N1978SWatson Jeffry T · Colorado Springs, COBuilt 1976 · S/N CE-640N1978TSilva Daniel · Mapleton, ILBuilt 1974 · S/N 18263132N1978UKilbourn Aldean G · Fairbanks, AKBuilt 1970 · S/N 18501718N1978WFlytighe LLC · Winchendon, MABuilt 2021 · S/N 5009N1979Whitley Jason · Southlake, TXBuilt 1979 · S/N E-1568N1979BLink John E · Hereford, TXBuilt 1979 · S/N 79-30925N1979TOmalley Theodore J · Willow, AKBuilt 1978 · S/N 18503686N1979UDreger Dean R · Wilbur, WABuilt 1970 · S/N 18501723N197BLAm Aviation LLC · Boerne, TXBuilt 2008 · S/N 31-0097N197BZGlide Away LLC · Wilburton, OKBuilt 1979 · S/N 18267326N197CMLester Labs LLC · Cloverdale, CABuilt 2018 · S/N 1723N197CPN197cp LLC · Columbus, GABuilt 2008 · S/N 3056N197CVJoseph F Gaar Jr Professional Law Corp · Lafayette, LABuilt 2016 · S/N 32-0001N197DHHintz Donald C · Punta Gorda, FLBuilt 1997 · S/N E-3084N197DTSzczerba Francis C · Cranberry Township, PABuilt 1997 · S/N 29-0113N197FTuin Brian A · Fort Worth, TXBuilt 1980 · S/N 18267671N197FMGainey Mark P · San Antonio, TXBuilt 1987 · S/N CE-1131N197MVrechek Joseph Rvt · Fort Lauderdale, FLS/N 286N197QUrban Andrew W · Sun Prairie, WIBuilt 1965 · S/N D-7930N197RDean Clay · Cleveland, TXBuilt 1974 · S/N E520N197RDCrockett R · Glenwood Springs, COBuilt 1978 · S/N 18503681N197RMHjh Aviation LLC · Gordo, ALBuilt 2007 · S/N 29-0495N197SRLakeside Roofing And Construction LLC · Yukon, OKBuilt 2007 · S/N 2547N197VMclaine James D · Clarion, PABuilt 1964 · S/N 18051416N1980HEf Aviation LLC · Cape Coral, FLS/N 28R-7703044N1981MOlson Robert Carter · Gold Canyon, AZBuilt 1976 · S/N 18264510
Back to AD 2000-23-21