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.

N1347SEskridge Steven Barry · Winona, MSBuilt 1976 · S/N 18264910N1348VBlake Joseph A · Jacksonville, FLBuilt 1976 · S/N R1722176N1349GWings Of Grace Ministries Inc · Melbourne, FLBuilt 1976 · S/N 310R0706N1349SSwiss Edm Wirecut Inc · Prospect Heights, ILBuilt 1976 · S/N 18264912N134ASmith Douglas O · Corvallis, ORFirst renewal noticeBuilt 1952 · S/N G-59N134AFSummerfield Douglas T · Mason City, IABuilt 1953 · S/N G-100N134AJTimmermans Jamy · San Jose, CABuilt 2005 · S/N 1511N134BBOcean Air Jet LLC · Cooper City, FLBuilt 2020 · S/N E-4134N134BSMueller Craig S · Bellaire, TXBuilt 1952 · S/N G-30N134CDL&L Aviation Inc · Advance, NCBuilt 1955 · S/N G-717N134CKZhukov Yuriy Olegovich · Harrisonburg, VABuilt 2010 · S/N 3690N134DVac Sys Holdings LLC · Roseville, CAS/N G-743N134DHBohlig Stephen W · Minnetonka, MNBuilt 1953 · S/N 34-78N134DRRothenanger David A · Talladega, ALBuilt 1956 · S/N BG-169N134DSDoge Aircraft LLC · Boca Raton, FLBuilt 1982 · S/N 348233148N134FLift Enterprises LLC · Lynn Haven, FLBuilt 1964 · S/N TC-816N134GGGibson Gordon S Trustee · Pacific Palisades, CABuilt 1981 · S/N 340A1202N134GLWhiskey Tango Aviation LLC · Owasso, OKBuilt 1955 · S/N G-732N134HRL&P Of Mke LLC · Milwaukee, WIBuilt 1955 · S/N G-745N134JCClark Julie E · Cameron Park, CAS/N G-812N134KCKw Plastics · Troy, ALBuilt 1953 · S/N G-78N134LCConklin Lynn A · Vacaville, CABuilt 1953 · S/N 53-4149N134LMRunck Russell E · Watertown, MNBuilt 1955 · S/N G-292N134MBLarsen Matthew J · Filer, IDS/N G-83N134MCByars John Jr · Houston, ALBuilt 1997 · S/N 29-0134N134MDAa Aviation LLC · Lewes, DES/N TJ-449N134MGCsa Aircraft Leasing LLC · Salt Lake City, UTBuilt 1981 · S/N 34-8233007N134MMGrace John M · Wickenburg, AZBuilt 1956 · S/N BG-299N134PGRegistration Pending · Chicago, ILRegistration pendingBuilt 2008 · S/N 1935N134RDDevere Albert R · Warrenton, VABuilt 1955 · S/N BG-11N134RRRussell Jon D · Calabasas, CABuilt 1957 · S/N BG-340N134SMCzech Six LLC · Lafayette, LABuilt 1957 · S/N BG-312N134SRZabala Jaime · Naples, FLBuilt 2006 · S/N 1894N134TC134tc LLC · Oklahoma City, OKBuilt 2019 · S/N 4808N134TDDonovan Gary L · Lake City, FLBuilt 1955 · S/N BG-79N134TFSpectre Aviation LLC · Exeter, NHBuilt 1993 · S/N CE-1764N134TTPlane Fun Inc Tr Trustee · Snellville, GABuilt 1953 · S/N G-305N134TXExperimental Aircraft Association Inc · Oshkosh, WIBuilt 1953 · S/N G-113N134YMentor Aviation LLC · Viera, FLS/N 140908N13500Caldwell Bob · Columbus, MSBuilt 1980 · S/N 18053168N1350SLo Pilato Family Flights Inc · Coral Gables, FLBuilt 1976 · S/N TH868N1350VCranor John David III · Fort Collins, COBuilt 1976 · S/N R1722178N1351G310 LLC · Conover, NCBuilt 1976 · S/N 310R0708N1351RN1351r Inc · Middletown, DEBuilt 1979 · S/N EA-21N1351SEllard James M · Danielsville, GABuilt 1976 · S/N 18264914N1351ZErickson David R · West Point, UTS/N TC-148N1352SEjw Enterprises LLC · Aguila, AZS/N 18264915N1352VAdventist World Aviation · Wilson, NCBuilt 1976 · S/N R1722179N1353LAviation Specialty Services LLC · Beaufort, NCBuilt 1978 · S/N 33701845N1353SHerrick Kendall D · Johnson, KSS/N 18264916
Back to AD 2000-23-21