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.

N428HSSchroebel John Daniel Trustee · Pleasant Hill, CABuilt 1965 · S/N 18256735N428JAJones Terry W · Houston, TXBuilt 2017 · S/N E-4104N428KRLilly James D · Columbia, MDBuilt 1972 · S/N D-9306N428RJSeneca Ez LLC · Weston, FLBuilt 1975 · S/N 347570250N428SRLautman Karl F Trustee · Los Angeles, CABuilt 2006 · S/N 2258N428TLight Korbin T · Midland, TXBuilt 2001 · S/N 0049N428TLJoe Rushing Plumbing Co Inc · Lubbock, TXBuilt 1967 · S/N D-8632N428TMBlue Jay Omni Bearing LLC · Fargo, NDS/N 0167N428WSSquires Wayne M · Corpus Christi, TXBuilt 2011 · S/N 0141N428XWillett Kyler James · Burbank, CABuilt 2008 · S/N 411076N428ZZDeans List Aviation LLC · Nashville, TNBuilt 2020 · S/N 4987N42907Albion Telephone Co · Albion, IDBuilt 1968 · S/N 18259247N42911Kenney Stuart C · Atlanta, GABuilt 1968 · S/N 18259249N42912Forouzan Fardad Trustee · Poway, CAS/N 18259250N42916Nedwick Lars I · Girdwood, AKS/N 18052384N42919Tarnutzer Aviation LLC · Wayland, MIBuilt 1968 · S/N 18259253N4291QRegistered aircraftBuilt 1976 · S/N U20603043N4293CNussbaum Rod M · Bradenton, FLS/N 28R-8331024N4293XTimothy G Turner · Oklahoma City, OKBuilt 1983 · S/N 34-8333043N42941Nistler Steve W · Helena, MTS/N 18259259N42946Perchard Baron D · Schaumburg, ILBuilt 1983 · S/N 28R-8331025N42947N42947 LLC · Panama City, FLBuilt 1968 · S/N 18259262N42949Niemeyer Donald C DBA · Hobart, INBuilt 1968 · S/N 18259263N42951Tiedt Randy · Parkville, MOBuilt 1968 · S/N 18259264N42955Brown Donald E Jr · Jonesboro, ARS/N 18259265N42958Havasa Enterprises LLC · Sisters, ORBuilt 1973 · S/N 18052389N4295ANy Fighter Jets · Wilmington, DES/N G-755N42967Brook Daniel L · Marshall, INBuilt 1968 · S/N 18259269N42968Jelinek Spencer T · Erie, COBuilt 1973 · S/N 18052390N42970Digbus Aviation LLC · Sheridan, WYS/N 28R-8331030N42972Anderson Mike D · Mc Alpin, FLBuilt 1968 · S/N 18259271N42974Tracy Lanning Construction LLC · Westminster, SCBuilt 1968 · S/N 18259272N4297547q LLC · Eau Claire, WIBuilt 1968 · S/N 18259273N4297YPalmer John · Duluth, MNBuilt 1983 · S/N 28R-8331029N42980Friday Dale C · Santa Cruz, CABuilt 1968 · S/N 18259274N4298YAir LLC · Fresno, CABuilt 2001 · S/N TH-1998N429CDQualitair LLC Trustee · MichelstadtBuilt 2004 · S/N 1064N429DLLandset David J · West Palm Beach, FLBuilt 1975 · S/N 21060649N429GLHamilton Verlon D · Roanoke, TXBuilt 1965 · S/N TC-868N429KRK Air LLC · Indianapolis, INBuilt 2025 · S/N 10785N429LDBonanza44 LLC · Fort Myers, FLBuilt 2016 · S/N E-4084N429MAirmart Inc · Lexington, KYBuilt 2014 · S/N TH-2422N429PDupuy William C · Waco, TXBuilt 2000 · S/N E-3356N429PCShanks Charles Scott · Edmonds, WAS/N 18051629N429PSMjk Leasing LLC · San Antonio, TXBuilt 2006 · S/N 29-0429N429RTrinity Point Enterpises LLC · Odessa, FLS/N E-4024N429RCN429rc LLC · Gladwyne, PABuilt 1979 · S/N 414A0243N429SBieker James · Eatonville, WABuilt 2004 · S/N 1399N429SRN205bp LLC · Sheridan, WYBuilt 2007 · S/N 2686N429TLLong Tracey · Cleveland, TNBuilt 1974 · S/N 34-7570001
Back to AD 2000-23-21