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.

N21291Castleair LLC · Dothan, ALBuilt 1972 · S/N 18261542N21297Bradley Robert S M Sr · Rougemont, NCBuilt 1972 · S/N 18261545N21299L-Bird LLC · Hood River, ORBuilt 1967 · S/N 337-M0005N2129DLoadholtz Heath T · Watford City, NDBuilt 1965 · S/N 18256143N2129FStewart Madison F Co Persona Representative · Broken Arrow, OKBuilt 1965 · S/N U206-0329N212ASKff Inc · Piscataway, NJBuilt 2001 · S/N TH-1995N212BKVitesse Aviation Holding I LLC · Englewood, NJBuilt 2009 · S/N 3558N212CCChristenson Charles F · Auburn, WABuilt 1966 · S/N 18257852N212CDBuckmaster Michael J · Richmond, INBuilt 2000 · S/N 1108N212CJJci Flight Management LLC · Tuscaloosa, ALBuilt 2008 · S/N 411065N212DMiller William K · Flat Rock, NCBuilt 2009 · S/N 31-0126N212DARegistration Pending · Phoenix, AZRegistration pendingBuilt 1972 · S/N U20601901N212DEWerre Joel F · Dunn Center, NDS/N EA-626N212DSFlying Bee Aviation LLC · Delphi, INBuilt 2023 · S/N 9539N212GBSooner Farms LLC · Siloam Springs, ARBuilt 1975 · S/N 21061130N212GWTim D Wilson Investigations Inc · Hempstead, TXS/N TE-494N212HRExport Aviation LLC · Santa Fe, NMS/N T30300239N212KTLanier Howard W · Willis, TXS/N P206-0349N212KYAerial Banners Inc · Pembroke Pines, FLBuilt 1951 · S/N 22301N212LCGenuine Aviation LLC · Rye Brook, NYBuilt 2016 · S/N 2323N212LLLunch Mony LLC · Fort Worth, TXBuilt 2016 · S/N 1236N212LVN212 Holdings Llp · Camden, DEBuilt 2005 · S/N 1547N212MHM L H Properties Inc · Rogers, ARBuilt 1998 · S/N E3209N212MLSeneca Aviation Inc · Wilmington, DEBuilt 1977 · S/N 34-7770205N212MMOlver Keith B · Annapolis, MDBuilt 2002 · S/N 0403N212PFFulton Robert Wilson III · Waxhaw, NCBuilt 2015 · S/N 2285N212PPLermer Christoph · Naples, FLBuilt 1990 · S/N TH-1604N212RNoodlebop Inc · Provincetown, MABuilt 2026 · S/N 11176N212RJBishop Mike · Rifle, COBuilt 1964 · S/N D-7467N212RRN2u Equipment Leasing LLC · Newark, DEBuilt 2021 · S/N 2357N212SRPegasus Flyers LLC · Queen Creek, AZBuilt 2006 · S/N 1871N212SWRarden Matthew W · Albuquerque, NMBuilt 1979 · S/N 18266842N212TAJensen Paul · Exeter, NEBuilt 2005 · S/N 29-0392N212TJ212tj LLC · Monterey, CABuilt 2004 · S/N 41038N212TSParkside Automotive & Truck Service · Mountain Top, PABuilt 1980 · S/N 21064214N212TWLeaving On Tulsa Time LLC · Tulsa, OKBuilt 2000 · S/N TH-1950N212TXCirrus Design Corp · Duluth, MNBuilt 2026 · S/N 11523N212VGuilfoyle Robert J · Fairhope, ALBuilt 1976 · S/N D-9851N212WKRbm Adventures LLC · Jamestown, NYBuilt 1979 · S/N P21000372N212WLPeace Jiles V · Easley, SCBuilt 1976 · S/N 18265082N212WVKoval John S Trustee · Marysville, OHBuilt 2022 · S/N 8950N21302Blackburn James E · Upland, CAS/N 18261549N2130KQualitair LLC Trustee · MichelstadtBuilt 1978 · S/N 28R-7931023N2130UZadora-Przylecki Karol · Sammamish, WABuilt 1979 · S/N 28R-7931093N21310Bagnell Enterprises LLC · Anaconda, MTBuilt 1972 · S/N 18261552N21314Merritt Robert · De Kalb, TXBuilt 1999 · S/N 30-0020N21315Clinical Anatomy Associates Inc · Mason, OHBuilt 1972 · S/N 18261556N21316Bohnert Jason F · Harrisonville, MOBuilt 1972 · S/N 18261557N21317Mathes Richard A · Byron, NYBuilt 1972 · S/N 18261558N2131FHerschberger Glen M · Willow, AKBuilt 1964 · S/N U206-0331
Back to AD 2000-23-21