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.

N163SDAre You Cirrus LLC · Glasgow, MTBuilt 2013 · S/N 0662N163SPAgriflite Services Inc · Wakarusa, INBuilt 1972 · S/N TE-872N163UHarbaugh Steven K · Austin, TXBuilt 1968 · S/N E-98N1643EYoung Michael T · Flower Mound, TXBuilt 1992 · S/N CE1643N1643TWilliams Rudder · Scottsboro, ALBuilt 1965 · S/N CD-989N1644CAero 290 LLC · Burlington, WIBuilt 1953 · S/N 30344N1644MBrown James E · Duluth, MNBuilt 1970 · S/N 18501847N1645CRoach Aviation LLC · Longview, TXBuilt 1953 · S/N 30345N1646TOrellana Willson Daniel · Hesperia, CABuilt 1973 · S/N 414-0426N1647MAmerimed Aviation LLC · Buford, GABuilt 1975 · S/N 18264400N1647ZSantana Barry W · Wasilla, AKBuilt 1962 · S/N 185-0447N1648MForsberg Aviation Inc · Elk Grove, CABuilt 1975 · S/N 18264401N1649MMitten Aero LLC · Lexington, MIS/N 18264402N164BBPorter Patrick J · Greensboro, NCBuilt 2004 · S/N 1128N164CDStovall Ryan T · Alpharetta, GABuilt 2000 · S/N 1069N164CPHighwings LLC · West Fargo, NDBuilt 2014 · S/N 0891N164CTBuckley Aviation LLC · Swainsboro, GABuilt 2016 · S/N 1267N164JDDominik James W · Golf, ILBuilt 1966 · S/N 18051816N164KFValiair Ltd Co Trustee · Casper, WYBuilt 2016 · S/N 1320N164KXN164kx LLC · Charlotte, NCBuilt 2015 · S/N 1064N164MDehaan David J · San Diego, CABuilt 2010 · S/N TH-2295N164MKKelley Michael P · Independence, ORBuilt 2019 · S/N KES-091N164TBBuzza Tim · Cudjoe Key, FLBuilt 2020 · S/N 2094N1650CBrokaw Samuel J · South Bend, INBuilt 1953 · S/N 30350N1650UWilson Joshua Allen · Mckinney, TXBuilt 1974 · S/N 20700250N1650ZRobinson Christopher C · Olivet, MIBuilt 1962 · S/N 185-0450N1651XPeters Mark E · Newport News, VABuilt 1975 · S/N 21060686N1652TBas Part Sales LLC · Greeley, COBuilt 1973 · S/N 414-0432N1652XBlackbridge Holdings LLC · Helena, MTBuilt 1975 · S/N 21060687N1653CLoveness Ghyrn E · Cave Creek, AZBuilt 1953 · S/N 30353N1655BIdle Acres Aviation LLC · Ridgeland, MSBuilt 1981 · S/N TC-2416N1655CMardis Nicky Lee · Goddard, KSBuilt 1953 · S/N 30355N1655XApostolou Gregory · Henderson, NVBuilt 1975 · S/N 21060690N1656CAnderson Thomas R · Seattle, WABuilt 1953 · S/N 30356N1656XAnderson George E · Newnan, GABuilt 1975 · S/N 21060691N1657CBrauchler Ben H · Hernando, MSBuilt 1953 · S/N 30357N1657MPrecision Design Inc · Wilimington, DEBuilt 1975 · S/N 18264403N1657XRowe William W · Provo, UTBuilt 1975 · S/N 21060692N1658AApplied Trails Research LLC · Staunton, VABuilt 1978 · S/N 18266315N1658URenfro Michael W · Bethel, AKBuilt 1974 · S/N 20700258N1659WTrim Aire Aviation Inc · Mexia, TXBuilt 1973 · S/N TC-1475N165AMitchell Flying Club Inc · Lees Summit, MOBuilt 1979 · S/N 18267062N165CDGray Andrew Trustee · San Diego, CABuilt 2000 · S/N 1070N165DBCloud 916 LLC · Dover, DEBuilt 1978 · S/N 18503624N165DFMarks James E · Valatie, NYBuilt 1967 · S/N 185-1267N165FDEck Management Company LLC · Kingman, KSBuilt 2025 · S/N 10565N165HPKessler William A Jr · Uvalde, TXBuilt 1981 · S/N E-1856N165JBN165jb LLC · Dayton, OHBuilt 2024 · S/N 10237N165JVHigh Desert Aviation And Aerobatics LLC · Pocatello, IDBuilt 1998 · S/N E-3180N165LMSig Cirrus LLC · Powell, OHBuilt 2014 · S/N 0960
Back to AD 2000-23-21