OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,133

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.

N4688BAufderhar Samuel E · Lopez Island, WAS/N 31487N4688CAeropod Inc · Aurora, COBuilt 1976 · S/N 18502877N4688ULeprechaun Air Service Inc · Syracuse, KSBuilt 1964 · S/N 18051388N4689CAeropod Inc · Aurora, COBuilt 1974 · S/N 18502596N4689QJohnson Tod W · Three Rivers, CABuilt 1972 · S/N 21059589N468ABrown Michael E · Wasilla, AKBuilt 1967 · S/N D-8548N468BBVensure Air LLC · Las Vegas, NVS/N 1264N468CCBountiful Flying Club LLC · Salt Lake City, UTS/N 18259357N468CDSoar Above LLC · Westminster, MDBuilt 2008 · S/N 3338N468CLVicash LLC · Dover, DEBuilt 2003 · S/N 42030N468DABulk Transfer LLC · Horseshoe Bay, TXBuilt 2006 · S/N 29-0417N468DEUtah State University Space Dynamics Laboratory · North Logan, UTBuilt 1967 · S/N 337M0312N468GTTreble Teal LLC · Hood River, ORBuilt 2008 · S/N 3199N468JPDolan John · Babylon, NYBuilt 2002 · S/N 1261N468KAJm Aero Holdings LLC · Naples, FLBuilt 2022 · S/N 8576N468KCSkyway Assets LLC · Hyde Park, UTBuilt 2025 · S/N 10639N468KWLance Johnson Ministries Inc · Calhoun, GABuilt 1962 · S/N 310G0058N468MBDelaware Aircraft Trust LLC Trustee · New Castle, DEBuilt 2010 · S/N 3679N468MREastern Aerospace LLC · Wilmington, DEBuilt 2009 · S/N 3559N468MSSturdivant Mike P Jr · Glendora, MSBuilt 1980 · S/N 21063969N468PN Fl Servicing LLC · Santa Rosa Beach, FLBuilt 2000 · S/N TH-1965N468PABrennan Engineering Inc · Gillette, WYBuilt 2013 · S/N T24002030N468PRMearns Aviation LLC · Wilmington, NCBuilt 2006 · S/N 1661N468PSVoigt Aviation Inc · Park Rapids, MNBuilt 1973 · S/N 18262256N468SEH & R Cirrus LLC · Vero Beach, FLBuilt 2015 · S/N 1161N468SRMarkoff M Daniel · Las Vegas, NVBuilt 1969 · S/N CE-276N468TRichards Christan E · Livonia, MIS/N CD-297N4690CGreen Aviation Inc · Manchester, MEBuilt 1974 · S/N 18502597N4690EButler Zachary N · Manassas, VABuilt 1982 · S/N 18268260N4690N4690n LLC · North Andover, MABuilt 1979 · S/N 18267289N4690UKim Hansen Co · Burley, IDBuilt 1979 · S/N U20605059N4691AAllen John L · Big Sandy, TNBuilt 1956 · S/N 32288N4691DSmith Kurt W · Henderson, NVS/N D-4879N4691KDenner Bruce R · Nashua, NHS/N 18263692N4692BTruitt Cory G · Centennial, WYS/N 31590N4692NWilliams Douglas J · Bristol, NHBuilt 1979 · S/N 18267290N4693BSutton Aircraft Salvage LLC · Palmer, AKS/N 31591N4693D4 Knots LLC · Flower Mound, TXBuilt 1957 · S/N D-4906N46941Haynes Aviation LLC · Caruthersville, MOS/N 35495N4694YKempton Chevrolet Buick Ltd · Safford, AZBuilt 1980 · S/N 21063988N4694ZKyro Consulting LLC · Williamsburg, VABuilt 1988 · S/N 4608115N4695AAgarwal Ravi · Bath, PABuilt 1983 · S/N P21000816N4696ASokol Dennis A · Milan, OHBuilt 1956 · S/N 32293N4696DWings Of Hope · Skiatook, OKS/N D-4876N4696K96 Kilo LLC · Modesto, CABuilt 1975 · S/N 18263697N4697KMorgan James D · Denali Park, AKBuilt 1975 · S/N 18263698N4698C98 Charlie LLC · Anchorage, AKBuilt 1974 · S/N 18502598N4698KRegistered aircraftBuilt 1975 · S/N 18263699N4698RCorl Jason · Stanton, CABuilt 1969 · S/N CE-277N4699AReed Aviation LLC · Pearl, MSBuilt 1956 · S/N 32296
Back to AD 2000-23-21