OpenAirDocs.org
AD 2000-23-21

Registered aircraft · 47,133

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.

N4743BAmstrup Norm D · North Pole, AKBuilt 1955 · S/N 31641N4743CFour Three Charlie LLC · Andover, MABuilt 1979 · S/N 21063608N4743DEss Partnership LLC · Waterford, MIBuilt 1957 · S/N 34843N4743ERegistered aircraftBuilt 1982 · S/N 18268265N4743NGallagher Jeff · Rio Oso, CABuilt 1979 · S/N 18267332N4743QHabersetzer Brian D · Brush Prairie, WABuilt 1967 · S/N 185-1197N4743TWeaver Matthew B · Kasilof, AKBuilt 1964 · S/N 1008N4743XAerotech Mapping Inc · Las Vegas, NVBuilt 1980 · S/N U20605530N47442Registration Pending · Columbus, NERegistration pendingS/N 28R-7703377N47445Premier Capital Enterprises LLC · Hurricane, UTBuilt 1977 · S/N 28R-7703379N47448Jib Inc · Groton, CTBuilt 1977 · S/N 34-7770396N4744CDesert Aviation LLC · Kingman, AZBuilt 1979 · S/N 21063609N4744K4744k LLC · Mesa, AZBuilt 1979 · S/N P21000275N4744VSettle David A · Lyons, KSBuilt 1967 · S/N 30073N47459Thompson James David · Newborn, GABuilt 1977 · S/N 28R-7703383N4745DRoman Steven T · Burgettstown, PABuilt 1957 · S/N 34845N4745NHowze William Scott · Robstown, TXBuilt 1979 · S/N 18267333N4745TLee Andrew L · Anchorage, AKBuilt 1965 · S/N 1015N4745VFiecke Rodney J · Cokato, MNS/N 30074N4746NDenham Stacy L · Chehalis, WABuilt 1979 · S/N 18267334N4746U4746u LLC · Sherman Oaks, CABuilt 1979 · S/N U20605079N47471Piper N47471 LLC · Granby, COBuilt 1977 · S/N 28R-7703384N4747CAlfred Joseph T · Pagosa Springs, COBuilt 1979 · S/N 21063611N4747JKavie Andrew J · Blaine, MNBuilt 1967 · S/N M-1019N4747KFloyd Don B · Snohomish, WAFirst renewal noticeBuilt 1979 · S/N P21000278N4747TRegistered aircraftBuilt 1965 · S/N 1013N4747VRegistered aircraftBuilt 1967 · S/N 30036N4748DLifting Spirits Research LLC · Pensacola, FLS/N 34848N4748USmith-Heffernan Heather · Frisco, TXBuilt 1965 · S/N 18051448N4749BNunley Tim L · Palmer, AKBuilt 1955 · S/N 31647N474AWCenturion Aviation LLC · Ada, MIBuilt 1981 · S/N P21000652N474BFDodson International Parts Inc · Rantoul, KSBuilt 1967 · S/N 18257984N474CDNiagara Airways LLC · Orchard Park, NYBuilt 2005 · S/N 1573N474DAAerosim Academy Inc · Sanford, FLBuilt 2007 · S/N 1799N474DBMr Restore Services Inc · Vero Beach, FLBuilt 1976 · S/N 310R0822N474DLPrasad Sanjeev K · Las Vegas, NVBuilt 1976 · S/N 310R0704N474GFBrion Tom B · Chugiak, AKBuilt 1967 · S/N 2020N474K5net4 LLC · Plano, TXBuilt 2026 · S/N 11152N474MMSeventy Weeks Management Inc · Las Vegas, NVBuilt 2006 · S/N 41704N474PDFlying Carpet Service LLC · Wilmington, DEBuilt 2020 · S/N 4936N474RLMassey Air Inc · Lucedale, MSBuilt 2011 · S/N 3820N474TDavis Joe Michael II · Arlington, WAS/N CD-298N474WASix Seat Single LLC · Dayton, OHBuilt 1981 · S/N 34-8133038N474WYSky 4 Holdings II LLC · Kaysville, UTBuilt 2026 · S/N 11364N474ZGarcia Robert Jr · Blanco, TXBuilt 1957 · S/N D-5220N4750BConley Michael A · Mount Blanchard, OHS/N 31648N4750DGraves Frank C · Nocona, TXBuilt 1957 · S/N 34850N4750FSouth Dakota Skydivers Inc · Sioux Falls, SDBuilt 1966 · S/N P206-0350N4750NSaez Brian · Gilboa, NYBuilt 1979 · S/N 18267337N4750QDelaware C Plane Inc · Wilmington, DES/N 185-1204
Back to AD 2000-23-21