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.

N22VCVictorcharlie LLC · Weston, MABuilt 2005 · S/N 1341N22VFAir Conejos LLC · El Paso, TXBuilt 1978 · S/N P21000106N22VXDo Good Things LLC · Port Orange, FLBuilt 1978 · S/N TJ-171N22WBHemingway Aviation LLC · Palm Beach Gardens, FLBuilt 2024 · S/N 10314N22WEWings Over Saluda Institute LLC · Wilmington, DEBuilt 2022 · S/N 9023N22WGCorpat Inc · Missoula, MTBuilt 1981 · S/N P21000733N22WLSchauer Henry A · Fort Collins, COBuilt 1966 · S/N CE-41N22WPMatulich Ronald G · Drytown, CABuilt 1967 · S/N TC-1045N22WSJ M Mcleod Farms LLC · Carthage, NCBuilt 1979 · S/N E-1506N22WUPlane Pro Aviation LLC · Shelby, NCBuilt 2006 · S/N 1647N22WXCisneros Corina · Belmont, NHBuilt 2002 · S/N 0281N22XDNokes James · Woodbury, TNBuilt 2003 · S/N 0531N22XGPixton Thomas J · Incline Village, NVBuilt 1966 · S/N D-8369N22XJSmile Air LLC · Vidalia, GABuilt 2012 · S/N 3835N22YYArjad Henry · Irvine, CABuilt 2003 · S/N L2K-144N22ZFEastern Stearman Inc Trustee · Leesburg, VABuilt 2006 · S/N 1902N22ZMAbkw Air Sunshine LLC · Wilmington, DEBuilt 2007 · S/N 2684N22ZV2 Blondes On Board LLC · Brenham, TXBuilt 1979 · S/N E-1570N2300CWasp Air LLC · Hamilton, MTBuilt 1953 · S/N 30600N2301XPetritsch Ryan · Warrington, PABuilt 1965 · S/N 18256201N2302CDuck & Goose Aviation Inc · St Simons Island, GABuilt 1997 · S/N E-3102N2302GDolce Aviation LLC · Hamilton, MTBuilt 1958 · S/N 51602N2302RNitz Michael W · Volente, TXBuilt 1964 · S/N 18255402N2302XSedation Vacation Pllc · Dalton, GABuilt 1965 · S/N 18256202N2303RRosborough Todd D · Medford, ORBuilt 1964 · S/N 18255403N2303VFindlay Fly Boys LLC · Findlay, OHBuilt 1998 · S/N E-3168N2303YBentz Fence Company Inc · Lewiston, IDBuilt 1971 · S/N 185-01868N2304CTumbleson Shelly L · San Antonio, TXBuilt 1953 · S/N 30604N2304GHigh Mountain Aviation LLC · Grand Junction, COBuilt 1958 · S/N 51604N2304XAbel Van A · Wichita, KSBuilt 1965 · S/N 18256204N2305CLatham Cory D · Great Bend, KSS/N 30605N2305GFratzke Nathan A · Sterling, AKBuilt 1958 · S/N 51605N2305RTorres Fernando A · Derwood, MDBuilt 1964 · S/N 18255405N2305XSale Reported · Rock Hill, SCSale reported, pending cancellationBuilt 1965 · S/N 18256205N2306DUS Navy - Owner · Jacksonville, FLBuilt 1979 · S/N 21063828N2306FBas Part Sales LLC · Greeley, COBuilt 1964 · S/N 21058506N2306RRenshaw Laurence A · Cave Creek, AZBuilt 1964 · S/N 18255406N2307CStuffmann Eric S · Orinda, CABuilt 1997 · S/N E-3107N2307FEads Kevin · Arley, ALBuilt 1964 · S/N 21058507N2307JMidwest Kilo Delta LLC · Clara City, MNBuilt 1997 · S/N EA-607N2307RSugiono Oliver C · San Marino, CABuilt 1964 · S/N 18255407N2307XCornwall Brady Evan M · Shelton, WABuilt 1965 · S/N 18256207N2309GEquipment & Machinery Appraisal LLC · Grand Junction, COBuilt 1958 · S/N 51609N230AAnders David W · Chandler, AZBuilt 1991 · S/N 1161N230BLafitte John B · Villa Rica, GABuilt 1966 · S/N U206-0625N230CARinehart Investment Group LLC · Forest Lake, MNBuilt 2011 · S/N 3821N230CDAcronut Cardinals LLC · Glen Allen, VABuilt 2001 · S/N 1121N230CSMckensington LLC · Draper, UTBuilt 2013 · S/N T24002005N230DAHot Seat Aviation · Blacksburg, VAS/N TC-387N230DDStrobe 33 LLC · Houston, TXBuilt 1978 · S/N CE-835
Back to AD 2000-23-21