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.

N3171DJohnson Donald B · Lino Lakes, MNBuilt 1955 · S/N 31969N3171FRockin Rt LLC · Smithfield, UTS/N 18257271N3171YDj Aviation LLC · Newburgh, INBuilt 1962 · S/N 18254171N3172DNorth State Aviators LLC · Cary, NCBuilt 1988 · S/N E-2454N3172EKruchten Larry A · Scottsdale, AZBuilt 1982 · S/N 18268237N3172KAnderson Stephen · Loveland, COBuilt 1988 · S/N E-2435N3172SSterling Flyers LLC · Lehi, UTS/N 18255672N3172YPeters Barry S · Montague, CABuilt 1962 · S/N 18254172N3173CMcgaha Justin L · Hooker, OKS/N 30972N3173FJames Pearl LLC · Norfolk, VABuilt 1966 · S/N 18257273N3173SCortese Farm And Ranch Inc · Fort Sumner, NMFirst renewal noticeBuilt 1964 · S/N 18255673N3173TAir Tango LLC · Martinez, GABuilt 1988 · S/N CE-1259N3173WFlying Hammer Aviation LLC · Crosslake, MNBuilt 1974 · S/N E-513N3174BBrydon Robert J · Lago Vista, TXBuilt 1994 · S/N TH-1724N3174DRegistered aircraftBuilt 1955 · S/N 31972N3174FRozier Harold H Jr · Blackshear, GABuilt 1966 · S/N 18257274N3174KLrs Dynamics Corp · Port Orange, FLBuilt 1988 · S/N CE-1265N3174QMclaughlin Daniel R · Xenia, OHBuilt 1967 · S/N 18258174N3174TChartwell Services Inc · Wilmington, DEBuilt 1998 · S/N TH-1874N3174UMorris Debbie L · Columbus, GABuilt 1963 · S/N 18254574N3175CClay Jason I · Imperial Beach, CABuilt 1954 · S/N 30974N3175FEstes Bernard R · Bumpass, VABuilt 1966 · S/N 18257275N3175PBarlow Michael Kevin · Griffin, GABuilt 1986 · S/N CE-1091N3175UKeller Richard J · Martinsburg, WVBuilt 1963 · S/N 18254575N3175WKristoffer & Co · Jacksonville, FLBuilt 1973 · S/N TC-1614N3175YPittman Joel C · Apple Valley, CABuilt 1962 · S/N 18254175N3176CYoung Thomas O · Battle Ground, WABuilt 1954 · S/N 30975N3176WTarvair Eclipse LLC · Burnsville, NCBuilt 1988 · S/N E-2447N3176YThomas Steven Dale · Monticello, ILS/N 18254176N3177NBcs99 LLC · Peoria, ILBuilt 1988 · S/N E-2440N3177SFreeman William R · Lenexa, KSBuilt 1964 · S/N 18255677N3177VSmith Daniel P · St George, UTBuilt 1974 · S/N 15076409N3177WCraniatwo LLC · Peoria, ILBuilt 2000 · S/N TH-1967N3177YSkyknights Sport Parachute Club Inc · East Troy, WIFirst renewal noticeBuilt 1962 · S/N 18254177N3178AMarine Aviation LLC · New Bedford, MABuilt 1970 · S/N TH-3N3178DSager Kenneth A · Hummelstown, PABuilt 1955 · S/N 31976N3178YNiles Air LLC · Concord, NCBuilt 1962 · S/N 18254178N31799Kaschmitter Enterprises Inc · Grangeville, IDBuilt 1978 · S/N 34-7870266N3179CWoods Kevin M · Spokane, WABuilt 1954 · S/N 30978N3179DPreiss James M Trustee · Poplar Grove, ILBuilt 1955 · S/N 31977N3179FMoran Peter J · Como, MSBuilt 1966 · S/N 18257279N3179LPeregrine Aviation LLC · Oro Valley, AZBuilt 1965 · S/N 310J0179N3179YWolstein Joe M · Bigfork, MTBuilt 1962 · S/N 18254179N317AWilcox Jeffery · Fayetteville, TNBuilt 2006 · S/N 2105N317BDRegistered aircraftBuilt 1967 · S/N TE-317N317BPHorizon Dreams LLC · Homer, GABuilt 2021 · S/N 2268N317CAspn Aero LLC · Ostrander, OHBuilt 1995 · S/N EA-574N317CDBluecore Leadership LLC · Reston, VABuilt 2004 · S/N 0905N317CHCrestair Air LLC · Dover, DEBuilt 1973 · S/N D-9543N317EPMcelligott Michael J · Woodstock, VABuilt 1969 · S/N D-9044
Back to AD 2000-23-21