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.

N207NNCasaccio Paul E · Beesleys Point, NJBuilt 1969 · S/N 20700040N207PAMcnutt Ross T · Xenia, OHBuilt 1970 · S/N 20700162N207RBSutton Aircraft Salvage LLC · Palmer, AKBuilt 1980 · S/N 20700606N207RPAllen Brent H · Mammoth Lakes, CAS/N 25-2009N207SRJaars Inc · Waxhaw, NCS/N 20700623N207TFPhotos Unlimited Inc · Rancho Cordova, CABuilt 1978 · S/N 20700492N207VWVanderwel Mark E · Monroe, WABuilt 1975 · S/N 20700311N207WWalters William L · Boise, IDBuilt 1963 · S/N 18254647N207WMG A Associates LLC · Port Orange, FLBuilt 2008 · S/N 3360N207WTHenson Alan · Houston, TXBuilt 2000 · S/N E-3308N207YHGrant Aviation Inc · Anchorage, AKBuilt 1980 · S/N 20700637N207ZMInternational Air Services Inc Trustee · Carson City, NVBuilt 1993 · S/N TH1677N20801Loveland Christopher K · Meridian, IDBuilt 1973 · S/N 18261216N20803Goad Jimmy L · Bradford, ARBuilt 1972 · S/N 18261217N20805Welzenbach Craig L · Fair Oaks Ranch, TXBuilt 1972 · S/N 18261219N20806Young Todd Frederick · Pensacola, FLBuilt 1972 · S/N 18261220N2080JWoelfel Tim A · Madisonville, TXBuilt 1978 · S/N T18803370TN2080LSparks Halli · Burdett, NYBuilt 1976 · S/N D-9902N2080RTigert Tommy Ray · Ovilla, TXBuilt 1964 · S/N 18255280N2080SRobinson Earl J · Cotuit, MABuilt 1966 · S/N D-8357N20820Maugeri Thomas V · Frankfort, NYBuilt 1972 · S/N 18261232N20828Merrow R Loring · Beverly, MABuilt 1972 · S/N 18261238N2082GKennedy Daniel M · Boise, IDBuilt 1958 · S/N 51382N2082JCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 1978 · S/N T18803372TN2082KGolden Ranch Aviation Inc · Schriever, LABuilt 1978 · S/N 34-7970072N2082WRegistered aircraftBuilt 1965 · S/N D-8008N20831Olg Air LLC · Miami Gardens, FLS/N 18261239N20832Wallace Fred · Ada, OKBuilt 1972 · S/N 18261240N20836Morar Radu · Sutton, MABuilt 1972 · S/N 18261243N20838Madden John D · Bellenue, WABuilt 1972 · S/N 18261245N2083LHorizon Chaser LLC · Woodway, TXS/N D-9904N2083RSchutze Eric D Trustee · Ojai, CABuilt 1964 · S/N 18255283N2083SDave Schmauderer · Woodland, CAS/N 21061049N2083WKindig Eric J · Sidney, OHBuilt 1965 · S/N CD-990N20841Fox Creek Aviation LLC · Jackson, WYBuilt 1972 · S/N 18261248N20842Warner Kenneth G · Granbury, TXBuilt 1972 · S/N 18261249N20845Clark Bradley D · Kirkwood, ILFirst renewal noticeS/N 18261252N20849Tradewind Ventures LLC · Evans, GABuilt 1999 · S/N 30-0017N2084GFlying Farmers LLC · Hills, MNBuilt 1958 · S/N 51384N2084RTej Builds Air LLC · Winchester, VABuilt 1964 · S/N 18255284N2084SSecondhand Flying LLC · Ogden, UTBuilt 1975 · S/N 21061050N2084WBurkett James Austin III · New Port Richey, FLBuilt 1965 · S/N D-8009N2084XPrier Duncan M · Bonita Springs, FLBuilt 1965 · S/N 18256184N20852Spaulding Kenneth L · Sahuarita, AZBuilt 1972 · S/N 18261258N20854Branson Bonanza Club · Branson, MOBuilt 1972 · S/N 18261260N20855Mission Aviation LLC · Billings, MTBuilt 1972 · S/N 18261261N20856Pointon Martin J · Snohomish, WABuilt 1972 · S/N 18261262N20859Anderas Per R · Green Bay, WIS/N 18261264N2085GBackcountry Guys LLC · Prescott, AZS/N 51385N2085LFly More Drive Less LLC · Hot Springs, ARBuilt 1976 · S/N D-9908
Back to AD 2000-23-21