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.

N157DFair Haven Aviation LLC · San Francisco, CABuilt 2025 · S/N 10402N157ESCirrus Sr22 4386 Inc · Wilmington, DEBuilt 2016 · S/N 4386N157JHHendren Aviation LLC · Gravette, ARBuilt 2019 · S/N 4873N157JRSoft Landings LLC · Myrtle Beach, SCBuilt 1991 · S/N TH-1639N157LMBaughman David · Jeffersonville, INBuilt 1961 · S/N 21057764N157NNewsome Jeffrey S · Blackwell, OKBuilt 1976 · S/N TJ-52N157PGN777sb LLC · Helena, MTBuilt 2025 · S/N 11064N157RDedoming Russell C IV · Boylston, MABuilt 1991 · S/N CE-1636N157STogo Aviation Services LLC · Palmer, AKBuilt 1955 · S/N 31840N157SGRichland Aviation Inc · Sidney, MTBuilt 1973 · S/N 340-0154N157SRWildcat Aviation LLC · South Beach, ORBuilt 2022 · S/N 9024N157TTBluesky Air LLC · Georgetown, SCBuilt 2010 · S/N 411155N157TXHlebichuk David D · Montgomery, TXBuilt 2005 · S/N 1669N157VRoco Air LLC · San Antonio, TXBuilt 2005 · S/N 1472N157WFHelping Hands Partners II LLC · Wilmington, DEBuilt 2016 · S/N 1392N157ZLBrooks Aviation Inc · Douglas, GAS/N BG-355N1580ZLiebmann Christopher J · Tehachapi, CABuilt 1961 · S/N D-6879N1581CFitzgerald Kenneth J · Millwood, WABuilt 1953 · S/N 30281N1581GKovach Kenneth R · Jefferson, OHBuilt 1979 · S/N 310R1593N1582QWhite William Wayne · Corona, CABuilt 1977 · S/N 18503485N1582WWhite Dove Aviation LLC · Sidney, OHBuilt 1972 · S/N CD-1288N1582ZAugust Aero LLC · Kalispell, MTBuilt 1961 · S/N D-6880N1583SSmythe Errol J DBA · Bixby, OKBuilt 1962 · S/N CD-532N1583WNorton William P · Lakeville, MNBuilt 1972 · S/N D-9353N1584CHaakenson John R · Sterling, AKBuilt 1953 · S/N 30284N1584KJackson Aviation Inc · Dallas, TXBuilt 2007 · S/N 41779N1584SWhitlock Holdings LLC · Honey Grove, TXBuilt 1962 · S/N CD-534N1585CHamilton Mark W · Durango, COBuilt 1953 · S/N 30285N1585ZKnoche Matthew · Clarkston, MIBuilt 1961 · S/N D-6883N1586SWits End Travels Ltd · Wilmington, DEBuilt 1962 · S/N CD-535N1586ZJoe L Fisher · Downers Grove, ILBuilt 1961 · S/N D-6882N1587MSkywagons.Com LLC · Placerville, CAS/N 18264379N1587SGabay William G · Cocoa, FLBuilt 1962 · S/N TC-322N1587UGrant Aviation Inc · Anchorage, AKS/N 20700187N1587ZGlittenberg Bryson · Flower Mound, TXBuilt 1961 · S/N D-6876N1588Indianhead Aviation LLC · Polk City, IABuilt 1978 · S/N E-1290N1588MAnderson Aerial Spraying Service Inc · Canby, MNBuilt 1970 · S/N 18800688N1588SMava Aviation LLC · Fort Worth, TXBuilt 1962 · S/N CD-537N1588ZWalker Wesley F · Rock Hill, SCBuilt 1961 · S/N CD-436N1589LCain James W · Big Rapids, MIS/N D-9866N1589SHunton Paul S · Murfreesboro, TNBuilt 1962 · S/N CD-538N1589ZRiester Bernard J Jr · Auburn, NYBuilt 1961 · S/N CD-437N158BJbc Holdings LLC · Yarmouth, MEBuilt 2007 · S/N 2831N158BBStubbs J Phillip · Richmond, VABuilt 1975 · S/N TH-592N158BDJ L Aviation LLC · Jonesboro, ARBuilt 1979 · S/N TH-1045N158BHB58 LLC · Granger, INBuilt 1988 · S/N TH-1540N158BJPerfectus Inc · Wilmington, DES/N TH-324N158BMChorman Spraying LLC · Milton, DEBuilt 1981 · S/N TH-1244N158CFFrederick Cheryl A · Taylor, TXBuilt 2009 · S/N 158N158DNiehaus James O · Erie, COBuilt 1961 · S/N 1850232
Back to AD 2000-23-21