AD 2018-07-01

Registered aircraft · 346

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-01')
    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-01')
  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.

N313RXReach Air Medical Services LLC · Santa Rosa, CAS/N 1097N314PHPhi Health LLC · Tempe, AZBuilt 2005 · S/N 409N314RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2013 · S/N 1122N315MFQuad City Helicopter Emergency Medical Service · Davenport, IABuilt 2010 · S/N 0896N315RXAir Evac Ems Inc · O Fallon, MOBuilt 2013 · S/N 1146N316RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2014 · S/N 1148N317PHPhi Health LLC · Tempe, AZBuilt 2005 · S/N 423N317RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2008 · S/N 0752N317VUVanderbilt University Medical Center · Nashville, TNBuilt 2016 · S/N 1210N318RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2015 · S/N 1203N319RXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2016 · S/N 1223N31RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2012 · S/N 1087N320PHPhi Health LLC · Tempe, AZBuilt 2005 · S/N 0430N320TVBristow LLC · Lake Charles, LABuilt 2006 · S/N 0467N321LNAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0465N321RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2016 · S/N 1215N322RXReach Air Medical Services LLC · Mcclellan, CABuilt 2016 · S/N 1230N323PHPhi Health LLC · Tempe, AZBuilt 2005 · S/N 0434N323RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2017 · S/N 1257N324PHPhi Health LLC · Tempe, AZBuilt 2007 · S/N 0571N324RXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 1274N324XMBristow LLC · Lake Charles, LABuilt 2011 · S/N 0991N325DBBristow LLC · Lake Charles, LABuilt 2011 · S/N 0985N325PHPhi Health LLC · Tempe, AZFirst renewal noticeBuilt 2007 · S/N 0576N325RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2021 · S/N 2163N326PHPhi Health LLC · Tempe, AZBuilt 2006 · S/N 0435N326RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2021 · S/N 2164N327PHPhi Health LLC · Tempe, AZBuilt 2006 · S/N 0445N328PHPhi Health LLC · Tempe, AZBuilt 2006 · S/N 0450N328RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2023 · S/N 2203N329PHPhi Health LLC · Tempe, AZBuilt 2006 · S/N 0489N329RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2023 · S/N 2223N330PHPhi Health LLC · Tempe, AZBuilt 2006 · S/N 0514N332PHPhi Health LLC · Tempe, AZBuilt 2006 · S/N 0519N335DHMary Hitchcock Memorial Hospital · Lebanon, NHBuilt 2010 · S/N 0913N335MLMercy Hospital Springfield · Springfield, MOBuilt 2006 · S/N 0451N337PHPhi Health LLC · Tempe, AZBuilt 2006 · S/N 0456N344PHPhi Health LLC · Tempe, AZBuilt 2006 · S/N 0459N347MTNorth Shore-Lij And Yale New Haven Health Medical · Great Neck, NYBuilt 2013 · S/N 1147N348MHMaritime Helicopters · Homer, AKBuilt 2007 · S/N 0543N356AMAirbus Helicopters Inc · Grand Prairie, TXS/N 2364N356MPAltair Helicopter Service LLC · Marshfield, MABuilt 2000 · S/N 0163N362AHCharlotte Mecklenburg Hospital Authority · Charlotte, NCBuilt 2023 · S/N 2215N362GRAirbus Helicopters Inc · Grand Prairie, TXS/N 2352N363AHCharlotte Mecklenburg Hospital Authority · Charlotte, NCBuilt 2022 · S/N 2191N363GRAirbus Helicopters Inc · Grand Prairie, TXS/N 2353N364GRAirbus Helicopters Inc · Grand Prairie, TXS/N 2359N365GRAirbus Helicopters Inc · Grand Prairie, TXS/N 2362N366AHCharlotte Mecklenburg Hospital Authority · Charlotte, NCBuilt 2022 · S/N 2199N366GRAirbus Helicopters Inc · Grand Prairie, TXS/N 2366
Back to AD 2018-07-01