OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,135

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.

N106TNSecond Wind Enterprises LLC · Atlanta, GABuilt 2008 · S/N 31-0106N106TQRogers Scott · Asheville, NCBuilt 2007 · S/N 2633N106UMiha LLC · Dover, DEBuilt 1956 · S/N 32325N106VKenyon Joseph S · Fort Collins, COBuilt 1959 · S/N D-6009N106WSMarriott Ed · Manhattan Beach, CAS/N R172-0107N1070VKrebs Michael · Elkhorn, WIBuilt 1976 · S/N R1722101N1070WHill Richard P · Jacksonville Beach, FLBuilt 1973 · S/N CE-431N1070XMosby Group LLC · Edgerton, MOBuilt 1975 · S/N 34-7570199N1070ZSky West Aviation Inc Trustee · Albuquerque, NMBuilt 1990 · S/N 25-1222N10712Hall Air Inc · Weiner, ARBuilt 1961 · S/N TC-59N10714Tennessee Museum Of Aviation · Sevierville, TNBuilt 1951 · S/N 22748N10715Noyes Stephen S · Newburyport, MABuilt 1951 · S/N 22816N1071JMoore Bradford H · Severna Park, MDBuilt 1973 · S/N 71N1071MJesperson Kenneth R · Ekalaka, MTBuilt 1969 · S/N T210-0451N1071VAdvanced Disability Management Inc · Montgomery, TXBuilt 1976 · S/N R1722102N1071WPcs Air LLC · Middletown, PABuilt 1973 · S/N E-417N1072FGeorgia Air LLC · St Simons Island, GABuilt 1996 · S/N E-3002N1072JAcorn Veterinary Services · Woodstock, VABuilt 1973 · S/N 72N1072VHegrenes Bruce A · Duluth, MNBuilt 1976 · S/N R1722103N1073MScr Aviation LLC · Austin, TXBuilt 1975 · S/N 18264219N1073QRegistration Pending · Polo, MORegistration pendingBuilt 1963 · S/N 310H0073N1073SAlabama Department Of Transportation · Montgomery, ALBuilt 1996 · S/N TH-1773N1074FNorth River Air LLC · Fairbanks, AKBuilt 1975 · S/N 18502730N1074JShevitski Jeffrey · New Castle, PABuilt 1973 · S/N 74N1074WDreamweaver Aviation LLC · Citra, FLS/N CE-432N1075JTise Marcelo D · South Hackensack, NJBuilt 1973 · S/N 75N1075XFisher Creek Corp · Grove Hill, ALBuilt 1996 · S/N TH-1775N1076FCavu Clearing LLC · Center Harbor, NHS/N 18502732N1076JRichards Steven P · Lockport, NYBuilt 1973 · S/N 76N1076VBell Johnny S · Tokeland, WAS/N R1722107N1077ABabcock Mark E · Auburn, WABuilt 1977 · S/N 18503156N1077B85 Alpha Inc · Wilmington, DEBuilt 1957 · S/N D-4931N1077FScileppi Gregory S · Sea Island, GABuilt 1975 · S/N 18502733N1077JAlttitude With Attitude LLC · Elizabethtown, PAS/N 77N1077WPrewitt Russell · Statham, GABuilt 1973 · S/N E-420N1077YPainter No 2 LLC · Hillman, MIBuilt 1981 · S/N 25-0575N1078FWilliams Casey D · Wasilla, AKBuilt 1975 · S/N 18502734N1078SRegistered aircraftBuilt 1996 · S/N TH-1778N1079BMander Ronald L · Mooresville, NCBuilt 1981 · S/N 25-0577N1079QGriffin Marcus · Houston, TXBuilt 1963 · S/N 310H0079N107ABHobart Aviation Inc · Akron, OHBuilt 1977 · S/N 34-7770341N107AJAltitude Aviation LLC · West Point, GABuilt 2007 · S/N 2671N107AXCirrusly Flying LLC · Issaquah, WABuilt 2017 · S/N 1519N107BBTer-Bear LLC · Payson, AZBuilt 2016 · S/N 1235N107BCCjw Aviation LLC · San Antonio, TXS/N 3057N107BLVinland Aerodrome Inc · Baldwin City, KSBuilt 1970 · S/N 33701330N107CBR&Dsl Corp Trustee · Wilmington, DEBuilt 2008 · S/N 3244N107CDKhalil Hassan · Clarks Summit, PABuilt 2000 · S/N 1018N107DBSkymaster Stc LLC · Mena, ARS/N P3370034N107FTRoyce Aviation LLC · Greenville, MSS/N 340A0909
Back to AD 2000-23-21