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.

N1450CFreeland Christopher G · Brownwood, TXBuilt 1970 · S/N T21059318N1450MCrescent Solutions Group LLC · Camden, DEBuilt 1970 · S/N U20601450N1450SLocklear Jackie R · Concord, NCBuilt 1976 · S/N 18264998N1451GCox Keith L · Griffin, GABuilt 1962 · S/N TC-249N1451MSquatchair LLC · Roseburg, ORBuilt 1975 · S/N 18264335N1451XTrb Aviation Inc · Washington, DCBuilt 1975 · S/N 34-7570248N1452GPutnam Mitchell D · Lees Summit, MOBuilt 1962 · S/N CD-449N1452WMaxair LLC · Appleton, WIBuilt 2006 · S/N 41584N1453SVenice Flying Club Inc · Sarasota, FLBuilt 1976 · S/N 18265001N1454DCavu Aircraft LLC · Olympia, WABuilt 2007 · S/N 41743N1454GN1454g LLC · Knoxville, TNBuilt 1962 · S/N D-6914N1454QDarden Tyson · Wasilla, AKS/N U20602900N1454SJackson Mike · Lakeside, AZBuilt 1976 · S/N 18265002N1455GNell James E · Pagosa Springs, COBuilt 1962 · S/N D-6920N1456SPremium Holdings LLC · Spokane, WABuilt 1976 · S/N 18265004N1457CHillen Air Corp · Dothan, ALBuilt 2003 · S/N 0547N1457MStevenson William E · Sutton, AKBuilt 1970 · S/N U20601457N1458GBayles Peter T · Sulphur, LABuilt 1962 · S/N CD-463N1459GBeeson Chris · Graford, TXBuilt 1962 · S/N D-6917N1459MK And L Aviation Incorporated · Wilmington, DEBuilt 1969 · S/N U20601459N145AJKearns William A · Spokane, WABuilt 2006 · S/N 2082N145AWSteere Anna · New Albany, OHBuilt 2004 · S/N 1402N145DDemaray Russell N · Sedona, AZBuilt 1980 · S/N TC-2348N145EJKovamees Carl · Middleton, MAS/N 3383N145JGGeldermann Bert E · Friday Harbor, WABuilt 2005 · S/N L2K-230N145JKArcus Aero LLC · Bridgeport, TXBuilt 1965 · S/N 18051549N145JMA&K Aviation LLC · Lambertville, MIBuilt 1980 · S/N D-10334N145MTilley Steven E · Biddeford, MEBuilt 1977 · S/N D10061N145PPainter Bryan J · Renton, WABuilt 1963 · S/N 205-0332N145PCAerospace Trust Management LLC Trustee · Wilmington, DEBuilt 1973 · S/N 0383N145PGBurns James J · East Greenwich, RIBuilt 2008 · S/N 1916N145PLState Of Alaska · Anchorage, AKBuilt 1981 · S/N U20606141N145SRTiger Jones Aircraft Inc · Tampa, FLBuilt 2022 · S/N 9010N145SWShore Gerry · Inez, TXBuilt 1973 · S/N 310Q-0614N145TSBonanza A36 LLC · Wildwood, MOBuilt 1999 · S/N E-3235N145TTVenture Air Solutions Inc · Dallas, GABuilt 1977 · S/N 402B1333N145XBaron 55 LLC · Hutchinson, MNBuilt 1963 · S/N TC-507N14621De Creeft Joseph M · Homer, AKBuilt 1951 · S/N 21056N1462SRiverside Aviation LLC · Oakland, IABuilt 1976 · S/N 18265009N1464GClauson Edward Ptrust · Charlestown, RIBuilt 1962 · S/N CD-468N1464SRauch Andrew J · Timnath, COBuilt 1976 · S/N 18265011N1465MBig Mountain Construction LLC · La Grande, ORBuilt 1969 · S/N U20601465N1466MTabor Shayne · Renville, MNBuilt 1970 · S/N U20601466N1466SCombs Brent L · Dallas, SDBuilt 1976 · S/N 18265013N1467FJetceo LLC · Kalispell, MTBuilt 1975 · S/N 18502845N1467VLumpkin Aviation LLC · Dahlonega, GABuilt 1976 · S/N R1722194N1467XWilson David K · Mckinney, TXBuilt 1975 · S/N 34-7570252N14680Hendricks Aric W · Floydada, TXS/N 74-30643N14687Dalessio Enterprises Inc · Smithville, TNS/N 74-30671N1468CBruegman Colt Trustee · Wheatland, WYBuilt 2003 · S/N 0574
Back to AD 2000-23-21