OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,129

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.

N101FRFoxfly LLC · Red Bank, NJBuilt 2013 · S/N T24002037N101GHSan Diego Community College District · San Diego, CAS/N 18260875N101GKCramer Keith B · Paso Robles, CABuilt 1979 · S/N 28R-7931172N101GWPlan B Air LLC · Lago Vista, TXBuilt 2007 · S/N 2528N101HTWilder Bart M · Maryville, TNBuilt 1958 · S/N D-5722N101JHHi-Per Aviation Inc · Arroyo Grande, CABuilt 1972 · S/N 21059759N101JMSale Reported · Clay Center, KSSale reported, pending cancellationBuilt 1967 · S/N D-8459N101KGQualitair LLC Trustee · MichelstadtBuilt 1983 · S/N EA392N101KTBryan Jerry E · Kathleen, GABuilt 1978 · S/N 18266264N101MEIbs America Corp · Wilmington, DEBuilt 1969 · S/N 401A0130N101MLWesolowski Trevor · Berkeley, CABuilt 1981 · S/N 34-8233066N101MRStick The Landing Aviation LLC · Radford, VABuilt 2006 · S/N 1732N101MTAllman Air LLC · Blackstone, VABuilt 1969 · S/N P20600626N101MWMaroon Creek LLC · Aspen, COBuilt 2007 · S/N 2823N101NSNoyes Gerold W · Northfield Falls, VTBuilt 2005 · S/N 1588N101PAKeenan Mark · Chico, CABuilt 1979 · S/N EA-39N101PMKasper John D · Oxford, ALBuilt 2004 · S/N 42055N101PQValiair Limited Company Trustee · Casper, WYBuilt 1962 · S/N 21057932N101PTN28179 Inc · West Gilgo Beach, NYBuilt 2018 · S/N E-4113N101RGTree Air LLC · Vero Beach, FLBuilt 1967 · S/N 18258526N101SPHawkes Clark · Gillsville, GABuilt 1986 · S/N 18268562N101TCTcm Flying Club Inc · Mobile, ALBuilt 1968 · S/N 18259330N101TPSamurai Ventures LLC · Hillsborough, CABuilt 2025 · S/N 10479N101UKInternational Air Services Inc Trustee · Carson City, NVBuilt 1981 · S/N 250631N101VMKrowel Nicholas E · Woodstock, GABuilt 2001 · S/N 0109N101WEBadgerland Aero LLC · Las Vegas, NVBuilt 1971 · S/N D-9231N101WPScc Associates Ltd · Wilmington, DEBuilt 1975 · S/N 18264220N101XMMaier Gerard · Hartford, WIBuilt 2004 · S/N 1226N101ZACirrus Sr22 10117 Inc Trustee · Wilmington, DEBuilt 2024 · S/N 10117N1020AIrving Donald J · Deland, FLBuilt 2003 · S/N 29-0316N1020MWinner Philip · Houston, TXBuilt 1975 · S/N 18264208N1020VCraig Air Inc · Wasilla, AKBuilt 1974 · S/N U20602404N1021CRiener Clinton G · Cottonwood, IDBuilt 1966 · S/N 18257409N1021URegistered aircraftBuilt 2004 · S/N 29-0325N1021WGreystone Enterprises Inc · Oklahoma City, OKBuilt 1973 · S/N E-401N10222Willard Gregory M · Bonita Springs, FLBuilt 2009 · S/N 411141N1022FGoodfellow Malcolm D · Seattle, WABuilt 1975 · S/N 18502690N1022MHilton David L · Shreveport, LABuilt 1975 · S/N 18264209N1022UCivil Precast Corp · Ridgeland, MSBuilt 2007 · S/N 31-0066N1023FWinter Karl · Litchfield Park, AZBuilt 1975 · S/N 18502691N1023WGoldeagle Flyers Inc · San Jose, CABuilt 1973 · S/N CE-421N1024Calgonaire LLC · Seminole, TXS/N 57425N10242Alexander Holding Services Inc · Newark, DEBuilt 1972 · S/N 21059704N1024MEdwards Chris R · Meadow Vista, CABuilt 1975 · S/N 18264210N1024TBarnwell John Randel · Conroe, TXBuilt 1976 · S/N D-9941N1024ZAqua Men Service LLC · Temple, GABuilt 2005 · S/N 41097N1025MSupina Robert P · Richmond, TXBuilt 1975 · S/N 18264211N1025VAviation Partners LLC · Highlands Ranch, COBuilt 1976 · S/N R1722086N1025WBancroft Maurice J · Rio, WIBuilt 1973 · S/N D-9453N1026ASouthern Aircraft Consultancy Inc Trustee · Casper, WYBuilt 2004 · S/N 290321
Back to AD 2000-23-21