OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,133

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.

N435RMBryant Lyle W · Ellinwood, KSBuilt 1963 · S/N D-7258N435SRM2 Aviation LLC · Concord Township, OHBuilt 2006 · S/N 2022N435TXBorah Peak LLC · Austin, TXBuilt 2020 · S/N 2217N435WPPinpoint Locating Inc · Ashville, ALBuilt 2025 · S/N 10613N4360MOwen Kevin R Trustee · Camdenton, MOBuilt 1984 · S/N 34-8433058N4360VMb Powers Inc · Thompsons Station, TNBuilt 1984 · S/N 46-8408051N43613Piper Aircraft Inc · Vero Beach, FLBuilt 1984 · S/N 34-8433068N4362WReaume Andrew G · Wayne, PABuilt 1974 · S/N E-557N4363LVeritas Holdings LLC · Washington, DCBuilt 1984 · S/N 46-8408056N4363MArk 84 LLC · Wilmington, DES/N 46-8408058N4364QStotts Boys Aviation LLC · Corcoran, MNBuilt 1973 · S/N 18502239N4365VPfander Scott J · Litchfield Park, AZBuilt 1972 · S/N 73-30487N4366WPrentice Chris · Independence, ORBuilt 1974 · S/N D-9620N4366ZEse Aviation LLC · Houston, TXBuilt 1984 · S/N 46-8408069N4369XSand Duane A · Bismarck, NDBuilt 1975 · S/N 34-7670030N436ATWheels Up LLC · Aloca, TNBuilt 1978 · S/N TH-953N436CDSky West Aviation Inc Trustee · Albuquerque, NMBuilt 2005 · S/N 1522N436CPAeronauncents LLC · El Paso, TXBuilt 2008 · S/N 3266N436DGGetting Dean W · Fort Dodge, IABuilt 1978 · S/N E-1213N436EButcher Gregory E · Pensacola, FLBuilt 1964 · S/N D-7532N436EUStevann Farms Ltd · De Witt, IABuilt 2005 · S/N E-3612N436JB700p LLC · Lewes, DEBuilt 1976 · S/N D-9884N436MHaase LLC Series 5 · Henderson, NVBuilt 1990 · S/N EA-512N436PHaydon Douglas A · Yorba Linda, CABuilt 1965 · S/N CD-984N436PSKramer James E · Nashville, TNBuilt 2007 · S/N 29-0490N436RADebon Corp · La Center, WABuilt 1999 · S/N E-3270N436SN436s LLC · Fernandina Beach, FLBuilt 2007 · S/N E-3776N436TYoung Robson Terry · Kirkland, ILBuilt 1963 · S/N D-7240N4370WHincha Stacie B · Thatcher, AZBuilt 1974 · S/N E-559N4371WRussell Chris J · Cheyenne, WYBuilt 1974 · S/N CE-501N4372BTyler Hendry Dds Inc · Glendale, CABuilt 1984 · S/N 46-8408083N4372EPad Aviation LLC · New Castle, DEBuilt 1984 · S/N 46-8408085N4372FMalibu Aviation LLC · Haslet, TXS/N 46-8408086N4372LSteen Douglas S · Cresson, TXBuilt 1984 · S/N 46-8408087N4373WDreamline Aviation LLC · Saint Petersburg, FLBuilt 1974 · S/N TC-1696N4374MThursby William T · Cedar Hill, TXBuilt 1979 · S/N E-1589N4375PShea Roger · Alta, WYBuilt 1985 · S/N 46-8508031N4375WTouch N Go Aeroworks LLC · Greenville, SCS/N TH-489N43761Gedney Greg Monroe · Denver, COBuilt 1977 · S/N 28R-7703310N43764Bas Part Sales LLC · Greeley, COBuilt 1977 · S/N 28R-7703312N4376APeavy Ricky Tod · Gainesville, GABuilt 1984 · S/N 46-8508004N4376RMoore Michael J · Mountain Brk, ALBuilt 1969 · S/N CJ-14N4376WSmith Ryan · Canby, ORBuilt 1974 · S/N D-9626N4377ATebeaux William Jene · College Station, TXBuilt 1984 · S/N 46-8508008N4377GD&P Enterprises Inc · Fresno, CABuilt 1985 · S/N TJ-479N43794Ochoa Luis M · Hollywood, FLBuilt 1977 · S/N 28R-7703314N437ALBier Ervin D · Locust Grove, GABuilt 1981 · S/N 348133156N437CWestacott Simon · Fenwick Island, DEBuilt 2002 · S/N 0375N437EMagic Shuttle Bus Air Tours LLC · Traverse City, MIBuilt 1966 · S/N D-8179N437KMAce Holdings LLC · Sioux Falls, SDBuilt 2022 · S/N 8693
Back to AD 2000-23-21