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.

N176LFFour Basics LLC · Olathe, KSBuilt 1977 · S/N E-1052N176LLClear Above LLC · Haymarket, VABuilt 1975 · S/N 21061135N176MMRair Air Inc · Stateline, NVBuilt 1976 · S/N 310R0710N176PSJr Barragan Inc · Chowchilla, CABuilt 2006 · S/N 2249N176QBse & Associates Inc · Sacramento, CABuilt 2019 · S/N 1898N176RKY-12 Investments LLC · Alexandria, VABuilt 2020 · S/N TH-2532N176STCp A36 Inc · Knoxville, TNBuilt 1976 · S/N E-884N176TCRedtail Cirrus LLC · Boise, IDBuilt 1979 · S/N 18503814N176VBGraystoke Aviation LLC · Shepherd, MTBuilt 1976 · S/N D-9926N176WHarwell Evin Dtrustee · Howell, MIBuilt 1978 · S/N E-1335N176WEFlying D Labs LLC · Bend, ORBuilt 2016 · S/N 1283N176XClub Turbo 176 LLC · Santa Clara, CABuilt 1976 · S/N E868N176YCessna U206f Aviation LLC · Boise, IDS/N U206-03383N17702Bosley Blake R · Richmond, TXBuilt 1977 · S/N CE-701N17703Dakota Aviation LLC · Sioux Falls, SDBuilt 1977 · S/N E-1007N1770GJansen David C · Warm Springs, GABuilt 1962 · S/N TC-294N1770RRegistered aircraftBuilt 1974 · S/N 18502490N1770XPark Avenue Group Inc · Stuart, FLBuilt 1975 · S/N 21060791N17718Katzakian Philip O · Lodi, CABuilt 1977 · S/N D-9998N1771MGaley Matthew Blake · Greenwood, MSBuilt 1975 · S/N 18264433N17722International Jets Inc · Gig Harbor, WABuilt 1977 · S/N TC-2045N17726Air Commander LLC · Woodbury, MNBuilt 1977 · S/N TC-2046N1772WRichland Flight Academy LLC · Sidney, MTBuilt 1972 · S/N E-377N17732Wright Brian L · Franklin, TNBuilt 1977 · S/N TE-1102N17735Stoppelbein Colby · Kenansville, NCBuilt 1977 · S/N CE-703N17738Lambert Michael C · San Jose, CABuilt 1977 · S/N CE-702N1773WWade William C Trustee · Cottonwood, AZBuilt 1972 · S/N D-9413N1773ZMcclay David H · Lagrande, ORBuilt 1963 · S/N 336-0073N17746Hansen Christopher Smith Sr · Surf City, NCBuilt 1977 · S/N D-10003N17747Davis 180 LLC · Baton Rouge, LABuilt 1977 · S/N CE-704N17748Montineri Joseph A · Port Orange, FLBuilt 1977 · S/N E-1017N1774HPeacock Bruce M · Mendon, VTBuilt 1980 · S/N 18267507N17751Brewer Bret D · Woodward, OKBuilt 1977 · S/N D-10004N1775RAnderson Lenny R · King Salmon, AKBuilt 1974 · S/N 18502494N17764N17764 LLC · Quincy, WABuilt 1977 · S/N E-1021N17766Elworthy Steven M · Huntington Beach, CABuilt 1977 · S/N E-1023N17769Jmk Engineering Inc · Bloomfield Hills, MIBuilt 1977 · S/N E-1027N1776MBidfish Ventures LLC · Harrisonburg, VABuilt 2005 · S/N 1394N1776XAgl Aviation LLC · Temecula, CABuilt 2023 · S/N 9492N1777HFait Coleman B · Newport Beach, CABuilt 1959 · S/N 35877N17785Registered aircraftBuilt 1977 · S/N E-1025N1778UMission Aviation Fellowship · Nampa, IDS/N 20700378N17790Tds Property Holdings LLC · Gilmer, TXBuilt 1977 · S/N TC-2055N17791Spuza Dan D · Sanger, TXBuilt 1977 · S/N CE-708N17794Getting Dean W · Fort Dodge, IABuilt 1977 · S/N E-1029N17797Nieman James Lewis Jr · Alhambra, CABuilt 1977 · S/N D-10010N1779MBlagg Kevin · Dumas, ARBuilt 1975 · S/N 18264439N1779ZLewis Lionel · Tacoma, WABuilt 1963 · S/N 336-0079N177ABKostroski Larry J · Tucson, AZBuilt 1972 · S/N TE-873N177DGHesperia Construction Inc DBA · Ramona, CABuilt 1979 · S/N TJ-241
Back to AD 2000-23-21