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.

N1981XB2 Aviation LLC · Sisters, ORBuilt 1965 · S/N 18256081N1982RLaughlin Michael · Anchorage, AKBuilt 1975 · S/N U20602913N1982XWheeler Joseph T · Chandler, AZS/N 18256082N1983CRivera Carlos A · Morriston, FLBuilt 1955 · S/N 31572N1983UAlpine Air LLC · Cordova, AKBuilt 1970 · S/N 18501731N1983WTailwinds LLC · Houston, TXBuilt 1988 · S/N E-2423N1984MAnacapa Aviation LLC · Oxnard, CABuilt 2015 · S/N 4218N1984X140kts LLC · Quilcene, WABuilt 1965 · S/N 18256084N1985CCollins Bruce J · Caldwell, TXS/N D-7438N1985MSokalsky Leigh Anne · Monee, ILBuilt 1976 · S/N 18264514N1986PRegistered aircraftBuilt 2020 · S/N 2207N1987GPhillips Michael M · Angleton, TXBuilt 1974 · S/N 414-0544N1987HFour C Sons Inc · Kersey, COBuilt 1977 · S/N 28R-7703046N1988MFacility Concepts LLC · Jackson, MSBuilt 1976 · S/N 18264517N1988WAerobat Ventures LLC · Phoenix, AZBuilt 2018 · S/N E-4118N1988XN1988x LLC · Erie, COBuilt 1965 · S/N 18256088N1989HHogan Thomas J · San Diego, CABuilt 1977 · S/N 34-7770164N1989MCrosswind Aviation LLC · Friendswood, TXBuilt 1976 · S/N 18264518N198AZCoyote Aviation LLC · Ballston Spa, NYBuilt 1980 · S/N U20605961N198BArkla Aviation LLC · Farmerville, LABuilt 2000 · S/N TH-1936N198CMOff Rock Aviation LLC · Lewes, DEBuilt 1981 · S/N 34-8133250N198ERCloud Dancer LLC · Santa Maria, CABuilt 1977 · S/N 21062298N198JMBlazey James R · Palmyra, NYBuilt 1973 · S/N 18262235N198KRAddison Eddie M · Toccoa, GABuilt 2003 · S/N 020N198PBolski Dariusz · Rancho Cordova, CABuilt 1960 · S/N 57319N198PSDorsing Kevin G · Othello, WABuilt 1998 · S/N 3449051N198RPAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 1976 · S/N 210-61063N198SRCross Creek Aviation LLC · Bossier City, LABuilt 2007 · S/N 2679N198TBHonore Breen Aviation LLC · Allegan, MIBuilt 1980 · S/N 348070032N198VSkrow Works Inc · West Monroe, LABuilt 1969 · S/N 30214N1990XCedar Valley Lumber Company LLC · Fullerton, NEBuilt 1965 · S/N 18256090N19914Ursa Major Holdings LLC · Newark, DEBuilt 1981 · S/N 18053181N1991DCentral Virginia Aviation Inc · North Dinwiddie, VABuilt 1952 · S/N D-3250N1991LHarvatine Francis J · Sykesville, MDBuilt 1976 · S/N MC-431N1991PMyron Holdings LLC · Puyallup, WAS/N 18263326N1991XTree-O LLC · Daphne, ALBuilt 1965 · S/N 18256091N1992JWet Ever LLC · Gainesville, GABuilt 1999 · S/N 30-0042N1992XBush Richard A · Mccall, IDBuilt 1965 · S/N 18256092N1993BWalton Andrew C Trustee · Rocklin, CABuilt 2020 · S/N 2111N1993MPoskey Charles E · Alabaster, ALBuilt 1976 · S/N 18264522N1994MAgile Aviation LLC · Rotonda West, FLBuilt 1976 · S/N 18264523N1994UBoney C Steven · Bethel, AKBuilt 1970 · S/N 18501761N1994XCovenant Flyers LLC · Sharpsburg, GAS/N 18256094N1995AReeder James T · Ottawo, KSS/N CD-406N1995GHarris Justin R · Hico, TXFirst renewal noticeBuilt 1974 · S/N 414-0602N1995URegistered aircraftBuilt 1970 · S/N 18501764N1996MHarrison Dan H · Englewood, FLBuilt 1976 · S/N 18264525N1996USmith Aviation LLC · Sitka, AKBuilt 1970 · S/N 18501765N1997Church Aviation LLC · Christmas Valley, ORBuilt 2007 · S/N 41795N1997HScarry Daniel · San Luis Obispo, CABuilt 1977 · S/N 28R-7703047
Back to AD 2000-23-21