Skip to content

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

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

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.

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

Run it at the DuckDB prompt, or in any tool that reads Parquet over HTTPS. More ways to query the release are on Use the data.

N63RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2014 · S/N 7974 N64RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2017 · S/N 8346 N650HPKansas Highway Patrol · Topeka, KSBuilt 2024 · S/N 9397 N651CDepartment Of Homeland Security · Washington, DCBuilt 2021 · S/N 8868 N65RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2017 · S/N 8353 N661GKKip Construction Services Inc · Santa Clarita, CABuilt 2025 · S/N 9654 N670HPKansas Highway Patrol · Topeka, KSBuilt 2024 · S/N 9483 N670TTerrible Herbst Inc · Las Vegas, NVBuilt 2021 · S/N 8985 N674TXTexas Department Of Public Safety · Austin, TXBuilt 2023 · S/N 9306 N6798Department Of Homeland Security · Washington, DCBuilt 2021 · S/N 8934 N681ASRba LLC · Kimberly, IDBuilt 2001 · S/N 3328 N68RXReach Air Medical Services LLC · Mcclellan, CABuilt 2018 · S/N 8483 N694BBO307 LLC · Surprise, AZS/N 4005 N6968ATafy Consulting · Bristow, VABuilt 2013 · S/N 7530 N6974ADepartment Of Homeland Security · Washington, DCBuilt 2012 · S/N 7459 N6977ADepartment Of Homeland Security · Washington, DCBuilt 2012 · S/N 7463 N6981ADepartment Of Homeland Security · Washington, DCBuilt 2012 · S/N 7472 N6987ATafy Consulting · Bristow, VABuilt 2014 · S/N 7834 N69XVQuantum Leasing LLC · Scottsdale, AZBuilt 2022 · S/N 9307 N6UXHelicopters Inc · Cahokia, ILBuilt 2003 · S/N 3749 N700PECentaurus Flight LLC · Ojai, CABuilt 2017 · S/N 8406 N703WPCity Of Los Angeles · Van Nuys, CABuilt 2017 · S/N 8362 N704RHValiair Lc Trustee · Casper, WYBuilt 2018 · S/N 8467 N704WPCity Of Los Angeles · Van Nuys, CABuilt 2017 · S/N 8369 N708HPNs Air Leasing LLC · Wilmington, DEBuilt 1999 · S/N 3244 N708PDEast Bay Regional Park District · Livermore, CABuilt 2008 · S/N 4390 N710FKFlorida Keys Mosquito Control District · Marathon, FLBuilt 2019 · S/N 8702 N717CCHillsborough County Sheriffs Office · Tampa, FLBuilt 2026 · S/N 9900 N717CDHillsborough County Sheriffs Office · Tampa, FLBuilt 2018 · S/N 8505 N71HPOhio Department Of Public Safety · Columbus, OHBuilt 2018 · S/N 8515 N71LCLee County Sheriffs Office · Fort Myers, FLBuilt 2015 · S/N 7994 N720FKFlorida Keys Mosquito Control District · Marathon, FLBuilt 2019 · S/N 8726 N725AHBering Air Inc · Nome, AKBuilt 2024 · S/N 9592 N726AKTriple Tango LLC · Carlsbad, NMBuilt 2019 · S/N 8776 N72HPOhio Department Of Public Safety · Columbus, OHBuilt 2015 · S/N 7978 N730FKFlorida Keys Mosquito Control District · Marathon, FLBuilt 2022 · S/N 9350 N737JCPacific Copter Inc · Tamarac, FLS/N 9822 N73LCLee County Sheriffs Office · Fort Myers, FLBuilt 2022 · S/N 9356 N740FKFlorida Keys Mosquito Control District · Marathon, FLBuilt 2025 · S/N 9774 N740KCCity Of Oklahoma City · Oklahoma City, OKBuilt 2023 · S/N 9411 N741CDepartment Of Homeland Security · Washington, DCBuilt 2020 · S/N 8821 N741SMLas Vegas Metropolitan Police Department · North Las Vegas, NVBuilt 2022 · S/N 9180 N745MHMansfield Heliflight Inc · Milton, VTS/N 4975 N74WLCorpat Inc · Missoula, MTBuilt 2019 · S/N 8763 N751AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4455 N752AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4472 N753AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4483 N753EDepartment Of Homeland Security · Washington, DCBuilt 2021 · S/N 8924 N754AMUS Department Of Homeland Security · Washington, DCBuilt 2009 · S/N 4650 N755AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4500

Back to AD 2018-01-12 R1