OpenAirDocs.org
AD 2018-04-13

Registered aircraft · 1,373

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

N26FAFreymiller Aviation LLC · Oklahoma City, OKBuilt 2004 · S/N 20026N26FEFederal Express Leasing Corp · Memphis, TNBuilt 2012 · S/N 20358N270FXFleischer Russell · Cleveland, OHBuilt 2026 · S/N 55010194N270PCBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 2137N270QSRegistered aircraftBuilt 2025 · S/N 55010152N271QSRegistered aircraftBuilt 2025 · S/N 55010160N272BCBissell Inc · Grand Rapids, MIBuilt 2020 · S/N 20862N272BQJsv Aviation Ventures 272 LLC · Dallas, TXBuilt 2015 · S/N 20600N272FXTinicum Capital Aviation LLC · Cleveland, OHBuilt 2026 · S/N 55010196N272JGRegistered aircraftBuilt 2007 · S/N 20172N272QSRegistered aircraftBuilt 2025 · S/N 55010163N273FXBohutinsky Andrew · Cleveland, OHBuilt 2026 · S/N 55010197N273QSRegistered aircraftBuilt 2025 · S/N 55010168N274QSRegistered aircraftBuilt 2025 · S/N 55010170N275QSBalls Corner LLC · Oklahoma City, OKBuilt 2025 · S/N 55010174N276QSRegistered aircraftBuilt 2025 · S/N 55010176N277JHLughnasa Management LLC · Greenwich, CTBuilt 2019 · S/N 20796N277QSRegistered aircraftBuilt 2025 · S/N 55010179N278QSRegistered aircraftBuilt 2025 · S/N 55010181N279QSRegistered aircraftBuilt 2025 · S/N 55010184N280AFAflac Inc · Columbus, GABuilt 2017 · S/N 2129N280BLBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 2147N280BWTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 2082N280CCca Holdings LLC · Richmond, VABuilt 2015 · S/N 2077N280CCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 2005N280DKUltra Capital LLC · Ridgeland, MSBuilt 2015 · S/N 2087N280DXImagine 280 LLC · Fort Lauderdale, FLBuilt 2012 · S/N 2011N280FLN280fl LLC · Camden, DEBuilt 2023 · S/N 2261N280FWRegistered aircraftBuilt 2015 · S/N 2076N280GDGeneral Dynamics Ordnance And Tactical Systems Inc · Saint Petersburg, FLBuilt 2010 · S/N 2003N280GLHj Aviation LLC · Flowood, MSBuilt 2016 · S/N 2105N280GUTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 2002N280HLNsb Leasing LLC · Longwood, FLBuilt 2016 · S/N 2102N280JMJvm Management LLC · Glendale, AZBuilt 2020 · S/N 2216N280JR280 LLC · Mount Pleasant, SCBuilt 2018 · S/N 2150N280JWRegistered aircraftBuilt 2021 · S/N 2231N280KK30kk LLC · Salem, ORBuilt 2022 · S/N 2255N280KRBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 2040N280KXGjk LLC · Scottsdale, AZBuilt 2018 · S/N 2141N280LSPlane 79 LLC · Sterling Heights, MIBuilt 2014 · S/N 2001N280LVAsny Aviation LLC · Las Vegas, NVBuilt 2022 · S/N 2254N280MKKojaian Aviation Management LLC · Bloomfield Hills, MIBuilt 2017 · S/N 2127N280NENets Equipment Leasing LLC · Burlington, NJBuilt 2021 · S/N 2235N280PCBank Of Utah Trustee · Salt Lake City, UTBuilt 2017 · S/N 2130N280PDDe210 LLC · Atlanta, GABuilt 2016 · S/N 2108N280PQQuiros Group Aviation LLC · Guaynabo, PRBuilt 2014 · S/N 2042N280QABank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 2047N280QCQuikrete Aircraft Leasing LLC · Atlanta, GABuilt 2023 · S/N 2270N280QSRegistered aircraftBuilt 2025 · S/N 55010186N280RHBelmont Premier Servicing Consulting Group LLC · Phoenix, AZBuilt 2018 · S/N 2154
Back to AD 2018-04-13