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.

N171TXMigliorini Alexander P · Eureka, CABuilt 2011 · S/N 0203N171UNancy Unicorn LLC · Seattle, WABuilt 1982 · S/N 18268147N171VTShly Aviation LLC · Carnegie, PABuilt 2002 · S/N 0142N171WBYeager Hal J · Winterset, IABuilt 1975 · S/N 18264036N171XLifto Patrick J · Miles City, MTBuilt 1962 · S/N D-5857N171YCesarano Billy · Maryville, TNBuilt 1958 · S/N D-5467N1720GRegistration Pending · Kalispell, MTRegistration pending, pending cancellationBuilt 1962 · S/N D-6943N1720XKregel Brian D · Garnavillo, IABuilt 1975 · S/N 21060742N1721Qualitair LLC Trustee · MichelstadtBuilt 1993 · S/N E-2783N1721CLemons Air LLC · Boulder, COS/N 30421N1721GCorlett Samuel E · Fort Worth, TXBuilt 1962 · S/N D-6944N1722CA G Sholton Co · Wasilla, AKBuilt 1953 · S/N 30422N1722HWashington State Community College · Spokane, WABuilt 1959 · S/N 35822N1722TNoldin John · Griffith, INS/N D-7139N1723BBoyko George · Tarpon Springs, FLBuilt 1979 · S/N 206-05190N1723CDi Gangi Stephen S · Spokane, WABuilt 1953 · S/N 30423N1723GDillahunty Chris D · Shaver Lake, CAS/N CD-486N1723MStahlman Richard D · Beaverton, ORS/N 33701323N1724CLentz Walter E · Duncan, OKBuilt 1953 · S/N 30424N1724GNelson Debra L · Presque Isle, MEBuilt 1962 · S/N CD-487N1724MDickehut Donna C · Cloverdale, INBuilt 1971 · S/N 33701324N1724THanna David B · Tonasket, WABuilt 1964 · S/N 21058360N1724XN2200b LLC · Cicero, NYBuilt 2014 · S/N 4090N1725CC Wolf Inc · Ord, NEBuilt 1953 · S/N 30425N1725MAirbach LLC · Irvington, KYBuilt 1975 · S/N 18264418N1725WEdwards John G · Stoneville, NCS/N D-9400N1725ZDavid B Curliss · Beavercreek, OHBuilt 1963 · S/N 336-0025N1726RPetumenos Timothy J · Anchorage, AKBuilt 1974 · S/N 18502447N1727CCarr Richard A · Boulder City, NVBuilt 1954 · S/N 30427N17281Martin Air LLC · Fort Wayne, INBuilt 1960 · S/N 50774N1728CMasek Lawrence J · Cuyahoga Falls, OHBuilt 1953 · S/N 30428N1728GMeyer Fred F · Hampshire, ILBuilt 1962 · S/N D-6946N1728MAnderson Michael · Missoula, MTBuilt 1975 · S/N 18264419N1728RIcenogle Roger A · Inver Grove, MNBuilt 1974 · S/N 18502449N1729CN8969v LLC · Anchorage, AKBuilt 1953 · S/N 30429N1729FAllmann Mark F Trustee · Kent, WABuilt 1954 · S/N 30619N172AAStuart S Macpherson Dds Inc · Cardiff By The Sea, CABuilt 1954 · S/N 30757N172CBRed Rock Aircraft Leasing LLC · Hurricane, UTBuilt 1977 · S/N R1722290N172CXBias Aviation LLC · Crossville, TNBuilt 1980 · S/N R1723373N172DDMurphy Dylan James · Murphys, CAFirst renewal noticeBuilt 1977 · S/N R1722547N172DHSanta Lucia 930 LLC · Greenwich, CTBuilt 2014 · S/N TH-2403N172QBonanza N172q LLC · Cedarburg, WIS/N D-7292N172REStinchcomb Jonathan C · Palmer, AKS/N 0041N172SPLuke Airlines LLC · Southgate, MIBuilt 1977 · S/N R172-2842N172XCisar Matthew Alexander · Eglin Afb, FLS/N D-6766N172XPTrapp Thomas A · Salem, CTBuilt 1979 · S/N R1723088N17307Vince John Gregory · West Ossipee, NHBuilt 1951 · S/N 22041N1730ATapley Brian K · Dothan, ALBuilt 1988 · S/N 89-301004N1730ZLoftis Kenneth L · Phoenix, AZBuilt 1963 · S/N 336-0030N1731HDonadio Robert F · Amherst, NHS/N 35831
Back to AD 2000-23-21