OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,142

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.

N136TBColwell Paul · Scottsdale, AZBuilt 2001 · S/N E-3419N136TCWeis Samuel K · Madera, CABuilt 1979 · S/N EA-15N136TPSchacher Daniel E · Muleshoe, TXBuilt 1977 · S/N E-1176N136TTTyulyaev Vitaly N · Chesterfield, MOBuilt 2010 · S/N 411161N136TVReid Brian M · Boise, IDBuilt 1958 · S/N 51388N136XNautical Skies LLC · Helena, MTS/N D-6215N137Bigfoot Aviation LLC · Saint Michael, MNBuilt 1960 · S/N 310-0028N1370QEvans Randall B Trustee · Fallon, NVBuilt 1977 · S/N 18503480N1370SGolfbanks Leasing Partnership · Geneva, INBuilt 1976 · S/N 18264933N1371GFall Gregory F · Hanson, MABuilt 1976 · S/N 310R0725N1372VBoland Matthew S · Anchorage, AKS/N U20602588N1373FBaczewski Gary L · San Antonio, TXBuilt 1975 · S/N 18502837N1374LB&B Exploration LLC · Lighthouse Point, FLBuilt 2006 · S/N 41579N1374SRenninger Log Homes · Meeker, COS/N 18264936N1375LAviation Specialty Services LLC · Beaufort, NCBuilt 1978 · S/N 33701867N1376ACook Coby · Camp Verde, AZBuilt 1969 · S/N E-170N1376SClarklind Farms · Tulare, CAS/N 18264938N1377ZCoen Brady · Wiley, COBuilt 1961 · S/N TC-165N1378SEngle William A · Bend, ORBuilt 1976 · S/N 18264940N1379C79 Charlie LLC · Knoxville, TNS/N 0541N1379GTwo Golf Tango LLC · Albuquerque, NMBuilt 1976 · S/N 340A0078N1379SMorris William Alan · Newnan, GABuilt 1976 · S/N 18264941N137BFJetstream Ventures LLC · Polson, MTBuilt 2013 · S/N E-3999N137CBEdmiston Brandon L · Murray, KYBuilt 1967 · S/N R1720146N137CMCm Aviation Inc Trustee · Wilmington, DEBuilt 1984 · S/N CE1054N137DMiller Aviation LLC DBA · Huntington, INBuilt 1981 · S/N 310R2136N137FSmith Nathan · Citra, FLBuilt 1956 · S/N TE-32N137GBCalm Air Aviation · Nunica, MIBuilt 2006 · S/N 42538N137LKStubby Wings LLC · Eden Prairie, MNBuilt 1981 · S/N 18504219N137LUAircraft Guaranty Corp Trustee · Oklahoma City, OKBuilt 2004 · S/N 1021N137MCPoland Gilbert Guardian · Dothan, ALBuilt 1965 · S/N 337-0127N137PEB & C Aero LLC · San Luis Obispo, CABuilt 2001 · S/N 0008N137PTXair LLC · Cloudcroft, NMBuilt 2008 · S/N 31-0115N137SRForeman Guy W · Valparaiso, INS/N 1916N137TMFlyin 2 LLC · Hyde Park, UTBuilt 2020 · S/N 2202N137TWDixon Daniel N · Millersville, MDBuilt 1974 · S/N D-9631N1382CBerman Aviation LLC · Tulsa, OKBuilt 2003 · S/N 0534N1382MRegan Arthur R · Green Valley, AZBuilt 1975 · S/N 18264305N1382VPropair400 LLC · Middletown, DEBuilt 2006 · S/N 41653N1383GKuper Carl J II · Dalhart, TXBuilt 1976 · S/N 340A0082N1383ZFrancis Rick Trustee · Pleasanton, CABuilt 2020 · S/N 2224N1384LCo Fire Aviation Leasing Inc · Fort Morgan, COBuilt 1978 · S/N 33701876N1384MGolfestate Flyer LLC · Winter Garden, FLBuilt 2023 · S/N 9178N1384SAdventure Aviation LLC · Fresno, CABuilt 1976 · S/N 18264946N1385LWhiskey River Aviation LLC · Medford, ORBuilt 1978 · S/N 33701877N1385MPecha James C · Binghamton, NYBuilt 1975 · S/N 18264307N1385V303 Tango Charlie LLC · Newark, DEBuilt 1984 · S/N T30300266N1386EWitsoe Kathleen · Knoxville, TNBuilt 1982 · S/N 18268176N1386MJohnson Shannon L · Granite Falls, MNBuilt 1971 · S/N 18260826N1386SLangel Joseph J · Lakeville, MNBuilt 1976 · S/N 18264947
Back to AD 2000-23-21