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.

N760KCCity Of Oklahoma City · Oklahoma City, OKBuilt 2025 · S/N 9739 N763AEAmerican Helicopters LLC · Kirkland, WABuilt 2014 · S/N 7789 N764MCLee County Mosquito Control District · Lehigh Acres, FLBuilt 2017 · S/N 8411 N765MCLee County Mosquito Control District · Lehigh Acres, FLBuilt 2017 · S/N 8423 N766MCLee County Mosquito Control District · Lehigh Acres, FLBuilt 2017 · S/N 8428 N770KCAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9960 N773XGooseneck Inc · Heber City, UTBuilt 2009 · S/N 4773 N775TCUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3622 N777CTVertical Corp · Kalispell, MTBuilt 2001 · S/N 3395 N779GCGranite Coast Mapping · Coronado, CABuilt 2009 · S/N 4630 N779MHMansfield Aviation International LLC · Wilmington, DES/N 3477 N781BCBroward County Sheriffs Office · Fort Lauderdale, FLBuilt 2024 · S/N 9448 N782BCBroward County Sheriffs Office · Fort Lauderdale, FLBuilt 2017 · S/N 8404 N783BCBroward County Sheriff'S Office · Fort Lauderdale, FLBuilt 2017 · S/N 8417 N789LPShier Aviation Corp · San Diego, CAS/N 7907 N78BK2 Aircraft Holdings LLC · Pasadena, CAS/N 8545 N790AMUS Department Of Homeland Security · Washington, DCBuilt 2007 · S/N 4298 N791AMUS Department Of Homeland Security · Washington, DCBuilt 2007 · S/N 4335 N792AMUS Department Of Homeland Security · Washington, DCBuilt 2007 · S/N 4362 N793AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4413 N794AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4440 N796AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4550 N7AJN315ja LLC · Anacortes, WABuilt 2023 · S/N 9315 N7HEIkarus Aviation LLC · Salt Lake City, UTBuilt 2000 · S/N 3269 N800KCFlying Nut LLC · Artesia, NMBuilt 2013 · S/N 7519 N801CXSalt Lake City Mosquito Abatement District · Salt Lake City, UTBuilt 2025 · S/N 9725 N803CPBaltimore County Maryland · Middle River, MDBuilt 2023 · S/N 9371 N804CPBaltimore County Government · Baltimore, MDBuilt 2006 · S/N 4133 N804PAPathfinder Leasing LLC · Anchorage, AKBuilt 2004 · S/N 3782 N805BTBeta Fleet LLC · South Burlington, VTBuilt 2002 · S/N 3563 N805LFAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 4559 N806MPNs Air Leasing LLC · Wilmington, DEBuilt 2008 · S/N 4504 N806PAPathfinder Leasing LLC · Anchorage, AKBuilt 2002 · S/N 3635 N807AMUS Department Of Homeland Security · Washington, DCBuilt 2008 · S/N 4592 N807LFAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 4928 N807MLRio Bravo Helicopters Inc · Dover, DEBuilt 2008 · S/N 4411 N808CPBaltimore County Government · Baltimore, MDBuilt 2006 · S/N 4151 N808LFAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 4983 N80HVOuter Banks Holdings LLC · Santa Fe, NMBuilt 2019 · S/N 8728 N810CESouthern California Edison · Chino, CABuilt 2006 · S/N 4112 N810LFAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 7015 N814FCentral Copters Inc · Belgrade, MTBuilt 2013 · S/N 7784 N814MCMartin County Sheriffs Office · Stuart, FLBuilt 2021 · S/N 8871 N814SMAir Methods LLC · Greenwood Village, COBuilt 2010 · S/N 7012 N814XSpeculator Air LLC · Billings, MTBuilt 2019 · S/N 8703 N816CESouthern California Edison Co · Chino, CABuilt 2009 · S/N 4724 N817CESouthern California Edison Co · Chino, CABuilt 2007 · S/N 4209 N818HAHelinet Aviation Services LLC · Van Nuys, CABuilt 2005 · S/N 3901 N818PDCity Of Glendale · Glendale, CABuilt 2025 · S/N 9642 N819TXTexas Department Of Public Safety · Austin, TXBuilt 2012 · S/N 7287

Back to AD 2018-01-12 R1