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.

N1605MSelter Eric Jay Trustee · Agoura Hills, CABuilt 1977 · S/N 21061950N1606WParagon Airplane Leasing Co · Fort Myers, FLBuilt 1972 · S/N TC-1467N1607CAmos Walt · Sandy, UTBuilt 1953 · S/N 30307N1608CMiller Gerald Roy · Denver, NCBuilt 1953 · S/N 30308N1609CBerry John C · Thunderbolt, GABuilt 1953 · S/N 30309N1609FHeneghan Tim S · Auburn, WABuilt 1973 · S/N 18052316N1609XHarvey P J · Midland, TXBuilt 1975 · S/N 21060645N160CPN160cp LLC · Kalispell, MTBuilt 2006 · S/N 1751N160EUSkyfusion II LLC · Atlanta, GAFirst renewal noticeBuilt 2003 · S/N 0759N160MCHaiasi LLC · Wilmington, DEBuilt 2010 · S/N 411160N160PYeager Robert F · Cuyahoga Falls, OHBuilt 1962 · S/N 18254278N160PBHyannis Air Service Inc · Hyannis, MABuilt 1981 · S/N 402C0493N160PGYoung Jared Lee · Fitzgerald, GABuilt 2008 · S/N 2995N160SPAerospace Trust Management LLC Trustee · Wilmington, DES/N D-9615N160SRSarl Cirrus Marine Inc Trustee · Cheyenne, WYBuilt 2006 · S/N 2161N160UCrane Rental Service Inc · Tempe, AZBuilt 1960 · S/N CJ-9N1610MBreuer Lisa · Horseshoe Bend, IDBuilt 1975 · S/N 18264395N1612CBeck Robert A · Cove, ORBuilt 1953 · S/N 30312N1613MMclaughlin Drew V · Anchorage, AKBuilt 1970 · S/N 18501833N1614CMaggie L Air Service LLC · Kalispell, MTS/N 30314N1615XBvi Aviation LLC · Wilmington, DEBuilt 1975 · S/N 21060651N1616CCleared Direct LLC · Seville, OHBuilt 1953 · S/N 30316N1617CRetroair Restoration LLC · Big Lake, AKBuilt 1953 · S/N 30317N1618AOne Eight Alpha LLC · Rch Palos Vrd, CABuilt 2024 · S/N 9918N1618MFluckey Gary T · Homer, AKBuilt 1970 · S/N 18501834N1618TRandolph James · Greensburg, PABuilt 1973 · S/N 414-0398N1619WExecutive Aircraft Management LLC · Northport, ALBuilt 1972 · S/N TE-869N161CDGreen Slip LLC · Valparaiso, INBuilt 2020 · S/N 2088N161CTEddy Company Inc · Apple Valley, CABuilt 1984 · S/N 18268414N161EWalsh David E · North Platte, NEBuilt 1956 · S/N 32692N161JKCenter Point Aviation LLC · Pensacola, FLBuilt 2007 · S/N 2462N161JWRjss Aviation LLC · Portland, ORS/N 0762N161KCCk Aviation LLC · Melbourne, ARBuilt 1980 · S/N E-1700N161KWKirtland Aero Club · Albuquerque, NMBuilt 1976 · S/N R1722002N161MCHamilton Clayton S · Carrizo Springs, TXBuilt 2008 · S/N 411020N161MPJb Aviation LLC · Newark, OHBuilt 1992 · S/N 24-3276N161RBower Fredrick S · Watervliet, MIS/N TE-365N161RMTurbine Screws LLC · Bozeman, MTBuilt 1980 · S/N 414A0450N161SRMcfc Inc · Hood River, ORBuilt 2006 · S/N 2120N161TRRambo Timothy B · Nampa, IDBuilt 1991 · S/N CE-1619N161VPConservation Aviation LLC · Washington, DCBuilt 1971 · S/N U20601719N161WCater Christopher B · Lowell, MIBuilt 1965 · S/N D-7914N1620BNatrix Aviation LLC · Sagaponack, NYBuilt 2026 · S/N 11275N1621WColeman Alan · Tyler, TXBuilt 1972 · S/N TC-1455N1622CPutnal Aviation LLC · Ambrose, GABuilt 1953 · S/N 30322N1622TMcpherson Bruce A · Burien, WABuilt 1962 · S/N NAV-4-2468N1622WN83993 LLC · Cherry Hill, NJExpired dealerBuilt 1972 · S/N TE-870N1623MMountain Ranch Air Inc · Sioux Falls, SDS/N 18264396N1623VHues Oulton A Jr · Norwood, MABuilt 1976 · S/N R1722206N1624HSynergy Aviation LLC · Forest Lake, MNBuilt 1977 · S/N 18503317
Back to AD 2000-23-21