AD 2002-23-19

Registered aircraft · 486

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:2002-23-19')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2002-23-19')
  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.

N860PSLbma Equipment Services Inc · Newburgh, NYBuilt 2021 · S/N 380N865PKPilot Travel Centers LLC · Knoxville, TNBuilt 2013 · S/N 707N865WWRegistered aircraftBuilt 2020 · S/N 367N868SHHca Squared LLC · Nashville, TNBuilt 2019 · S/N 360N86HDHomerlease Co Inc · Atlanta, GABuilt 2012 · S/N 250N870ARFtc Air Holdings LLC · Tampa, FLBuilt 1997 · S/N 46N870SBSimmons First National Corp · Little Rock, ARBuilt 2019 · S/N 743N878MMCentury Skies LLC · Englewood, COBuilt 2005 · S/N 51N87HDHomerlease Co Inc · Atlanta, GABuilt 2015 · S/N 307N880PCPromega Corp · Madison, WIFirst renewal noticeBuilt 2008 · S/N 138N880VJAce Listenger Enterprises LLC · Louisville, KYBuilt 2004 · S/N 26N881ADDna Air LLC · Wilmington, DEBuilt 2001 · S/N 136N881CECeoc LLC · Las Vegas, NVBuilt 2020 · S/N 368N882ADDna Air LLC · Wilmington, DEBuilt 2002 · S/N 185N883CECeoc LLC · Las Vegas, NVBuilt 2008 · S/N 158N887CECeoc LLC · Las Vegas, NVBuilt 2022 · S/N 391N8888Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 1996 · S/N 28N888FCBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 288N888NAIdeavillage Products Corp · Wayne, NJBuilt 1999 · S/N 77N888WLAir Sare One LLC · Delray Beach, FLBuilt 2005 · S/N 69N889MUGf Aircraft LLC · Tampa, FLBuilt 2002 · S/N 160N88DDRegistered aircraftBuilt 2013 · S/N 268N88GDKamali Aviation LLC · Great Neck, NYBuilt 1996 · S/N 30N890PSLbma Equipment Services Inc · Newburgh, NYBuilt 2021 · S/N 379N895MMRegistered aircraftBuilt 2023 · S/N 398N897DWarbler I LLC · Freeland, MIBuilt 2016 · S/N 328N899BCThabit Holding Co LLC · Sherman Oaks, CABuilt 2007 · S/N 132N89PMid-Atlantic Aviation V LLC · Saint Petersburg, FLBuilt 2007 · S/N 142N89RPRich Aviation Inc · Buffalo, NYBuilt 2006 · S/N 94N89RTRegistered aircraftBuilt 2021 · S/N 383N8SBSb Air LLC · Winchester, VABuilt 2014 · S/N 291N900EBSubaru Of New England Inc · Norwood, MABuilt 2025 · S/N 426N900SETmt Aviation LLC · Wichita Falls, TXBuilt 2007 · S/N 118N902AMBslcc-III LLC · Renton, WABuilt 2002 · S/N 206N902JJetran LLC · Horseshoe Bay, TXBuilt 2004 · S/N 214N902TFTyson Shared Services Inc · Springdale, ARBuilt 2020 · S/N 369N904RMAer Sales Lp · Carrollton, TXBuilt 2004 · S/N 41N905BTvpx Trust Co LLC Trustee · North Salt Lake, UTBuilt 2013 · S/N 267N909MMNalpak Consulting LLC · Santa Monica, CABuilt 2004 · S/N 38N909NFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 410N90BBBank Of Utah Trustee · Salt Lake City, UTBuilt 2015 · S/N 269N90MCAirex 3 LLC · Romulus, MIBuilt 2015 · S/N 322N9147HLenox Aviation II LLC · Lawrenceville, NJBuilt 2013 · S/N 709N914LDSdl Management Company LLC · Santa Ana, CABuilt 2003 · S/N 25N914MCMountaire Corp · Little Rock, ARBuilt 2015 · S/N 310N915FGFgf Sovereign LLC · Dallas, TXBuilt 2006 · S/N 107N915LGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2002 · S/N 182N918MJRegistered aircraftBuilt 2013 · S/N 270N919CHLeipold Aircraft LLC · Racine, WIS/N 205N920CERmhco LLC · Denver, COBuilt 2023 · S/N 399
Back to AD 2002-23-19