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.

N530LNAir Methods LLC · Greenwood Village, COS/N 0471N530MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2017 · S/N 2030N531LNAir Methods LLC · Greenwood Village, COFirst renewal noticeBuilt 2006 · S/N 0474N531MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 2052N533LCAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0555N533MECtr For Emergency Medicine Of Western Pennsylvania · West Mifflin, PABuilt 2020 · S/N 2133N534LNAir Methods LLC · Greenwood Village, COS/N 0453N534MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2020 · S/N 2134N535DETentacle Corp · Walnut Creek, CABuilt 2013 · S/N 1100N535LLMercy Hospital Springfield · Springfield, MOBuilt 2009 · S/N 0817N535LNAir Methods LLC · Greenwood Village, COBuilt 2004 · S/N 0365N535MTMed-Trans Corp · Lewisville, TXBuilt 2019 · S/N 2092N536MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2017 · S/N 2036N537MECenter For Emergency Medicine Of Western Pennsylva · West Mifflin, PABuilt 2020 · S/N 2136N544MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2023 · S/N 2244N549AMAir Methods LLC · Greenwood Village, COBuilt 2025 · S/N 2336N551HUAir Methods LLC · Greenwood Village, COBuilt 2006 · S/N 0490N555YEReach Air Medical Services LLC · Santa Rosa, CABuilt 2007 · S/N 0561N556MEAirbus Helicopters Inc · Grand Prairie, TXS/N 2356N556MTMed Trans Corp · Denton, TXBuilt 2017 · S/N 1253N558MTMed-Trans Corporation · Denton, TXBuilt 2012 · S/N 1073N565MEAirbus Helicopters Inc · Grand Prairie, TXS/N 2365N576MECenter For Emergency Medicine Of Western Pennsylva · West Mifflin, PABuilt 2024 · S/N 2276N577MTMed-Trans Corporation · Denton, TXBuilt 2017 · S/N 1249N579MECenter For Emergency Medicine Of Western Penn · West Mifflin, PABuilt 2024 · S/N 2279N586AMAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0709N586WHMetro Aviation Inc · Shreveport, LABuilt 2013 · S/N 1096N589MECenter For Emerg Med Of W Penn Stat Medevac Prog · West Mifflin, PABuilt 2022 · S/N 2189N590MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2022 · S/N 2190N599MSAir Med Services LLC · Lafayette, LAS/N 0684N600HNHealthnet Aeromedical Services Inc · Charleston, WVBuilt 2024 · S/N 2288N601MTMed-Trans Corp · Denton, TXBuilt 2012 · S/N 1040N602MTMed-Trans Corp · Denton, TXBuilt 2012 · S/N 1063N603MTMed-Trans Corp · Denton, TXBuilt 2022 · S/N 2182N608MTAirbus Helicopters Inc · Grand Prairie, TXBuilt 2025 · S/N 2334N608WGsh Crows Nest LLC · Boston, MABuilt 2007 · S/N 0575N615BDDeckoff Stephen H · St Thomas, VIBuilt 2015 · S/N 1193N615LFAir Methods LLC · Greenwood Village, COFirst renewal noticeBuilt 2004 · S/N 0362N620MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2025 · S/N 2320N635DHMetro Aviation Inc · Shreveport, LABuilt 2005 · S/N 0414N640ECMetro Aviation Inc · Shreveport, LABuilt 1998 · S/N 0064N641ECMetro Aviation Inc · Shreveport, LABuilt 2008 · S/N 0641N641MECtr For Emergency Medicine Of Western Pennsylvania · West Mifflin, PABuilt 2023 · S/N 2241N652ACAirbus Helicopters Inc · Grand Prairie, TXS/N 2357N655DVMed-Trans Corp · Denton, TXBuilt 2012 · S/N 1057N655JTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 1054N665MTMed-Trans Corp · Denton, TXBuilt 2006 · S/N 0466N691CMG200 LLC · San Juan, PRBuilt 2022 · S/N 2200N714GEPolar Star Corp · Kalispell, MTBuilt 1966 · S/N 0060N719LSMed Trans Corp · Denton, TXBuilt 2007 · S/N 0626
Back to AD 2018-07-01