OpenAirDocs.org
AD 2018-01-12 R1

Registered aircraft · 646

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

N91NSNs Air Leasing LLC · Wilmington, DEBuilt 2010 · S/N 7035N921HMObsidian Aircraft LLC · Boise, IDBuilt 2015 · S/N 7981N927MDepartment Of Homeland Security · Washington, DCBuilt 2020 · S/N 8791N929EDepartment Of Homeland Security · Washington, DCBuilt 2023 · S/N 9344N929NPMetro Nashville Police · Nashville, TNBuilt 2022 · S/N 9248N929TXTexas Department Of Public Safety · Austin, TXBuilt 2025 · S/N 9812N934EMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 7422N941EMReach Air Medical Services LLC · Santa Rosa, CABuilt 2014 · S/N 7854N942AEZuni LLC · Kirkland, WABuilt 2014 · S/N 7865N942EMReach Air Medical Services LLC · Santa Rosa, CABuilt 2014 · S/N 7844N943AEBoeing Co · Mesa, AZBuilt 2014 · S/N 7870N94RPAs350 LLC · Missoula, MTBuilt 2024 · S/N 9455N950FSTumbleweed Leasing Company Inc · Salt Lake City, UTS/N 3083N951RPCity Of Riverside · Riverside, CABuilt 2023 · S/N 9300N955AHBering Air Inc · Nome, AKBuilt 2025 · S/N 9876N969Box Family Aviation LLC · Denver, COBuilt 2024 · S/N 9670N970AEPhi Health LLC · Tempe, AZBuilt 1999 · S/N 3235N970WEWest Elk Air LLC · Gunnison, COBuilt 2005 · S/N 4037N973AEPhi Health LLC · Tempe, AZBuilt 1999 · S/N 3229N974HPCalifornia Highway Patrol · Sacramento, CABuilt 2014 · S/N 7871N975HPCalifornia Highway Patrol · Sacramento, CABuilt 2014 · S/N 7873N976HPCalifornia Highway Patrol · Sacramento, CABuilt 2014 · S/N 7881N978HPCalifornia Highway Patrol · Sacramento, CABuilt 2014 · S/N 7915N979HPCalifornia Highway Patrol Office Of Air Operations · Sacramento, CABuilt 2014 · S/N 7918N980MHRegistered aircraftBuilt 2022 · S/N 9108N981HPCalifornia Highway Patrol · Sacramento, CABuilt 2016 · S/N 8169N981TXAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9933N982HPCalifornia Highway Patrol · Sacramento, CABuilt 2016 · S/N 8187N983HPCalifornia Highway Patrol · Sacramento, CABuilt 2016 · S/N 8190N984HPCalifornia Highway Patrol · Sacramento, CABuilt 2019 · S/N 8653N985HPCalifornia Highway Patrol · Sacramento, CABuilt 2019 · S/N 8666N986HPCalifornia Highway Patrol · Sacramento, CABuilt 2023 · S/N 9394N988HPCalifornia Highway Patrol · Sacramento, CABuilt 2021 · S/N 8927N988MDMarine 1 LLC · Westport, CTBuilt 2019 · S/N 8686N992SDCounty Of Riverside · Hemet, CAS/N 3319N993SDCounty Of Riverside California · Hemet, CAS/N 4045N994SDCounty Of Riverside California · Hemet, CABuilt 2007 · S/N 4240N99523Ns Air Leasing LLC · Wilmington, DEBuilt 2001 · S/N 3461N995ASAog-Thurd Ferguson LLC · Corpus Christi, TXS/N 4138N995BCBrevard County Board Of County Commissioners · Titusville, FLBuilt 2013 · S/N 7556N996RSRiverside County Sheriffs Department · Hemet, CABuilt 2024 · S/N 9569N997SDCounty Of Riverside California · Hemet, CABuilt 2014 · S/N 7949N998NPAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2013 · S/N 7697N998SDCounty Of Riverside California · Hemet, CABuilt 2014 · S/N 7952N999SMAv I LLC · Girdwood, AKBuilt 2019 · S/N 8730N9FJFox Juliet LLC · Clearwater, FLBuilt 1998 · S/N 3148
Back to AD 2018-01-12 R1