OpenAirDocs.org
AD 2018-07-13

Registered aircraft · 967

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-07-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-07-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.

N502QSRegistered aircraftBuilt 2018 · S/N 680A0147N503QSRegistered aircraftBuilt 2016 · S/N 680A0040N503SVPerugia Air LLC · Dover, DEBuilt 2014 · S/N 680-0503N504QSRegistered aircraftBuilt 2016 · S/N 680A0041N505QSRegistered aircraftBuilt 2016 · S/N 680A0042N506QSRegistered aircraftBuilt 2016 · S/N 680A0043N506TXState Of Texas · Austin, TXBuilt 2021 · S/N 680A0260N507GCCloudbound Logistics LLC · Columbus, MSBuilt 2008 · S/N 680-0239N507GRBank Of Utah Trustee · Salt Lake City, UTBuilt 2026 · S/N 680A0469N507QSRegistered aircraftBuilt 2016 · S/N 680A0044N508QSRegistered aircraftBuilt 2015 · S/N 680A0014N508SFSnowwis Aviation LLC · Siloam Springs, ARBuilt 2017 · S/N 680A0101N509QSRegistered aircraftBuilt 2016 · S/N 680A0028N509SFSnowwis Aviation LLC · Siloam Springs, ARBuilt 2024 · S/N 680A0401N50WMTetondogz LLC · Helena, MTBuilt 2007 · S/N 510-0018N510AFCk Aviation LLC · Portage, MIBuilt 2009 · S/N 510-0244N510ATJcr Air LLC · Flower Mound, TXBuilt 2010 · S/N 510-0331N510AZJet Air LLC · Bend, ORBuilt 2008 · S/N 510-0124N510BDUinta Corp · Las Angeles, CABuilt 2009 · S/N 510-0249N510BEC510 Aviation LLC · Lakewood, COBuilt 2009 · S/N 510-0211N510CFEmpower Air 3 LLC · Richardson, TXBuilt 2007 · S/N 510-0045N510CJTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 510-0173N510DJFaith 510 LLC · Garland, TXS/N 510-0250N510DVPacific Cataract And Laser Institute Inc Pc · Chehalis, WAS/N 510-0461N510DWWhiskey Sierra Holdings LLC · Alto, NMBuilt 2007 · S/N 510-0025N510EEB&C Blue Sky III LLC · Augusta, GABuilt 2009 · S/N 510-0275N510EMVenrich LLC · Dallas, TXBuilt 2012 · S/N 510-0414N510ERGriffin Ranch LLC · Salem, ORBuilt 2016 · S/N 510-0469N510FDNc2 LLC · Las Vegas, NVBuilt 2012 · S/N 510-0420N510FFWfd & Mad LLC · Midland, TXS/N 510-0411N510GEFranplane Inc · Las Vegas, NVBuilt 2010 · S/N 510-0318N510GGShelton James M Jr · El Paso, TXBuilt 2009 · S/N 510-0168N510GJBg Aircraft N956gb LLC · Pinecrest, FLBuilt 2008 · S/N 510-0083N510HAKilo Mike Aviation LLC · Belton, TXBuilt 2009 · S/N 510-0166N510JKJ K Aviation Services LLC · Tampa, FLBuilt 2013 · S/N 510-0440N510JMPensford LLC · Waxhaw, NCBuilt 2007 · S/N 510-0051N510KMustang Air LLC · Sioux Falls, SDBuilt 2008 · S/N 510-0121N510KAOc 172 Group LLC · Saint Petersburg, FLBuilt 2008 · S/N 510-0081N510KBAviation Research And Maintenance · Christiansted, VIBuilt 2009 · S/N 510-0155N510KFClydesdale Asset Management LLC · Park City, UTBuilt 2010 · S/N 510-0354N510KMBayview Aviation LLC · Polson, MTBuilt 2010 · S/N 510-0323N510KZAltitude Aviation Group LLC · Irvine, CABuilt 2009 · S/N 510-0251N510LLGo Go Martin Enterprises LLC · La Verne, CABuilt 2008 · S/N 510-0074N510MRHigh Flight Academy LLC · Allison Park, PABuilt 2009 · S/N 510-0159N510MSPacific Pump And Power Corp · Kapolei, HIBuilt 2009 · S/N 510-0182N510MTNaf Aviation LLC · Key Largo, FLBuilt 2013 · S/N 510-0447N510MWBank Of Utah Trustee · Salt Lake City, UTBuilt 2008 · S/N 510-0109N510NZInversiones Flg Inc · Dorado, PRBuilt 2008 · S/N 510-0054N510PBAmber Holdings LLC · Salisbury, MDBuilt 2009 · S/N 510-0184N510PEFly High Mustang LLC · Wichita, KSBuilt 2008 · S/N 510-0059
Back to AD 2018-07-13