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.

N3803MRegistered aircraftBuilt 1980 · S/N D-10357N38040Mosier Daniel J · Tucson, AZBuilt 1980 · S/N EA-175N38049Moore Aviation Services LLC · San Antonio, TXBuilt 1980 · S/N EA-178N3804ABig Love LLC · Tifton, GABuilt 1983 · S/N TH-1381N3804DGabbert Lucious L · Prescott, AZBuilt 1957 · S/N 34504N3804MGlenmont Air LLC · Strasburg, VABuilt 1981 · S/N TJ-328N3804YChelmo Jed E · Kimball, SDBuilt 1964 · S/N 21058304N3805DThurier Lawrence V · Stevens Point, WIBuilt 1957 · S/N 34505N3805YMacys Flying Service Inc · Tulelake, CABuilt 1964 · S/N 21058305N38065Boyd David · Havasu, AZBuilt 1980 · S/N D-10361N3806LPeterson Ross D · Hutchinson, MNBuilt 1980 · S/N E-1793N3806VShirey Donnie W · Collinsville, OKBuilt 1977 · S/N R1722263N3806YOnion Crest Air LLC · Arcadia, NEBuilt 1964 · S/N 21058306N38071Carter Donald P Trustee · Merced, CABuilt 1980 · S/N CE-935N3807EDonaghe Larry Chance · Rockwall, TXBuilt 1981 · S/N E-1809N3807TAmbrose Construction Ltd · Corpus Christi, TXBuilt 1980 · S/N TJ-332N3807XAlpha Bravo Lima LLC · Covington, TNBuilt 1980 · S/N EA-179N38081Heitmeier Cody F · New Orleans, LAS/N E-1798N38082Pope Bill F · Prescott Valley, AZBuilt 1980 · S/N EA-183N38088Toledo Jorge A · Coral Gables, FLS/N TC-2366N38089Dabbs Randal L · Lenoir City, TNBuilt 1980 · S/N TH-1218N3808DByrd David P · King Salmon, AKBuilt 1957 · S/N 34508N3808QJordan Klein DBA · Summerfield, FLS/N CE-936N3809DRhoads William · Williamsburg, VABuilt 1957 · S/N 34509N3809XVoracek Michael G · Richardson, TXBuilt 1966 · S/N 310K-0209N380ASHacksaw Aviation LLC · Stamford, CTBuilt 2022 · S/N 8997N380BWKbns Aviation LLC · Morgan Hill, CABuilt 2020 · S/N 2157N380CDTomlinson Consulting LLC · Columbia, MDBuilt 2005 · S/N 1380N380CPBrady Craig · Mountain Brook, ALBuilt 2008 · S/N 3066N380CSRegistered aircraftBuilt 2016 · S/N T24002106N380LBryan Dale G Trustee · San Anselmo, CABuilt 2019 · S/N NLA-275-1001-SW-RNN380MMFolk Daniel H · Urbana, ILBuilt 1995 · S/N 29-0068N380PCRhomberg Bernard B · Elm Grove, WIBuilt 1978 · S/N E-1384N380SRRegistration Pending · Casper, WYRegistration pendingBuilt 2007 · S/N 2825N3810CBlake Thomas C · Vero Beach, FLBuilt 1981 · S/N TJ-335N3810DAdlard Thomas Andrew · Dinuba, CAS/N 34510N3810ZFalcon Ridge Industries Inc · Milleville, NJBuilt 1980 · S/N E-1802N3811DRegistration Pending · Turner, MTRegistration pending, pending cancellationBuilt 1957 · S/N 34511N3811XBaron 55 LLC · Hanover, NHBuilt 1981 · S/N TC-2368N38123Huber Weylin L · Aberdeen, SDBuilt 1977 · S/N 28R-7703178N3812KCook Steven A · Vineland, NJBuilt 1948 · S/N 3501N3812XJets And Props Corp · Reno, NVS/N 310K0212N3813GOne Three Golf LLC · Cleghorn, IABuilt 1977 · S/N 310R0916N3813QBemowski Paul · Madison, WIBuilt 1981 · S/N EA-187N3813XRegistered aircraftAssigned, pending cancellationS/N 310K0213N3813YSheppard David A · Jackson, CABuilt 1964 · S/N 21058313N3814DReeder Travis · Marana, AZBuilt 1957 · S/N 34514N3814YLadner Donald E · Centerville, TXS/N 21058314N3815DAlaska Homested Lodge Inc · Soldotna, AKBuilt 1957 · S/N 34515N3815KShoemaker James W · Hilltop Lakes, TXBuilt 1980 · S/N CE-939
Back to AD 2000-23-21