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.

N1759GVandergenugten Brian J · Schererville, INBuilt 1962 · S/N CD-501N175CDWilliams Jake Jr · Fayetteville, NCBuilt 2000 · S/N 1065N175DSSkyfall Aviation LLC · Maryville, TNBuilt 2024 · S/N 10257N175DYFirst Tracks Aviation LLC · Lewes, DEBuilt 2010 · S/N 3608N175LKern Charter Service Inc · Bakersfield, CABuilt 1977 · S/N E-985N175MHCharlie Michaels LLC · Helena, MTBuilt 2023 · S/N 9467N175MMHarden Jon R · Ijamsville, MDBuilt 1978 · S/N 18053032N175PGSpirit Aviators LLC · College Station, TXBuilt 2008 · S/N 1963N175SPN500aa LLC · Wilmington, DES/N 414A0313N175TPadgett Don K · Albuquerque, NMBuilt 1971 · S/N D-9259N175TTFarrell Dolliver T · Sterling, AKBuilt 1958 · S/N 55193N175USAtlas Property Management LLC · Broken Arrow, OKS/N 0570N17604Montgomery Aviation Corp · Montgomery, ALBuilt 1977 · S/N TE-1094N1760HReeve Howard E · Minot, NDBuilt 1959 · S/N 35860N1760MCoggin Patric D · Fort Smith, ARBuilt 1975 · S/N 18264427N17626Beaugrenelle Aero Inc · Wilmington, DEBuilt 1977 · S/N TC-2061N17639Peterson Eric S · San Jose, CABuilt 1977 · S/N E-997N1763MHaines Robert F · Carlsbad, CABuilt 1975 · S/N 18264429N1763W63 Whiskey LLC · Seattle, WABuilt 1973 · S/N E-406N1763XRobins Nest Aviation LLC · Harrison, OHBuilt 1975 · S/N 21060784N1764CRyan Michael · Gillette, WYS/N 30464N1764XLeschber Larry · Hutto, TXBuilt 1975 · S/N 21060785N17650Pynes Anthony P · Round Rock, TXBuilt 1977 · S/N D-9993N17651Basler Turbo Conversions LLC · Oshkosh, WIS/N R172-0137N17655Gray Stone Associates Inc · Knoxville, TNBuilt 1977 · S/N TC-2058N17656Liddell Patrick A · Columbia Falls, MTBuilt 1977 · S/N D-9995N1765GGivens Thomas A · Southern Pines, NCBuilt 1962 · S/N D-6964N1765HMcumber James W · Elkin, NCS/N 28R-7703034N1765MFlying Cow LLC · Syracuse, NYBuilt 1975 · S/N 18264430N17660Simpson Chad · Harrison, ARBuilt 1977 · S/N TH-810N17668Broadway Travis A · Alexandria, LABuilt 1977 · S/N E-1001N17669Srg Enterprises LLC · Montgomery, ALBuilt 1977 · S/N E-1002N1766HOrlandi Properties LLC · Blairstown, NJBuilt 1959 · S/N 35866N1766MN1776m LLC · Panama City, FLBuilt 1975 · S/N 18264431N1767GFranceus Maurice Michael · Temperance, MIBuilt 1962 · S/N CD-539N1767MAnderson Thomas C Trustee · Sun City West, AZBuilt 1975 · S/N 18264432N1767PSteciuk Paul B · Saratoga Springs, NYBuilt 2011 · S/N 0133N1767RHamel David A · Klamath Falls, ORBuilt 1974 · S/N 18502487N1767WN1767w LLC · Dover, DEBuilt 1972 · S/N TC-1500N1768ERoyal Air Freight Inc · Waterford, MIBuilt 1978 · S/N 310R1566N1768GRl Hoffman Aviation Services Inc · Sanders, KYBuilt 1962 · S/N CD-509N1768MWyoming Valley Air LLC · Old Forge, PAS/N 33701368N1768ZMoskowitz Craig B · Sheffield, MABuilt 1963 · S/N 336-0068N17692Starnes Robert D · Suwanee, GAS/N CE-700N17698Spindel Stuart H · Hawesville, KYBuilt 1977 · S/N E-1005N1769RCt Aviation LLC · Waverly, NEBuilt 1974 · S/N 18502489N176CFMbg Capital Holdings LLC · West Des Moines, IAS/N 3757N176EAHeath Mark R · Radisson, WIS/N R172-3440N176JMBinkowski John · Washingtn Twp, MIBuilt 2008 · S/N 411041N176KMAssociated Packaging Inc · Gallatin, TNBuilt 2019 · S/N 1851
Back to AD 2000-23-21