Registered aircraft · 1,086

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:2016-25-13') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-25-13') 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:2016-25-13')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-25-13')
  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:2016-25-13')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2016-25-13')
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.

N570AETemsco Helicopters Inc · Ketchikan, AKBuilt 2012 · S/N 7489 N574AMAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 4613 N576DTArea 109 LLC · Brooklyn, NYBuilt 2001 · S/N 760514 N577LFAir Methods LLC · Greenwood Village, COBuilt 2012 · S/N 7362 N582RDCity Of San Antonio · San Antonio, TXBuilt 2024 · S/N 9496 N583SHCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2013 · S/N 7567 N585AEPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3736 N590AEPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3733 N594LGAir Methods LLC · Greenwood Village, COBuilt 2026 · S/N 9923 N594MCEast Flagler Mosquito Control District · Palm Coast, FLBuilt 2023 · S/N 9405 N596LGAir Methods LLC · Greenwood Village, COBuilt 2026 · S/N 9901 N597LGAir Methods LLC · Greenwood Village, COBuilt 2026 · S/N 9885 N599SDPima County Sheriffs Department · Tucson, AZBuilt 2011 · S/N 7258 N5HAAshbaugh Hans · Elkhart, INBuilt 2018 · S/N 8645 N5PWPph145 LLC · Englewood, COBuilt 2021 · S/N 21032 N5SHIndiana Helicopters LLC · Fort Wayne, INS/N 8147 N600LLIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 1987 · S/N 6262 N600RSHella Fun 1 LLC · Belle Isle, FLS/N 7399 N601TATrans Aero LLC · Cheyenne, WYBuilt 2009 · S/N 4876 N604SPAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9868 N605AVAvera Mckennan · Sioux Falls, SDBuilt 2017 · S/N 20153 N607SPNew Mexico State Police Aircraft Section · Santa Fe, NMBuilt 2018 · S/N 20174 N608GVMente LLC · Kirkland, WABuilt 2021 · S/N 21003 N60NTCity Of Ontario · Ontario, CABuilt 2017 · S/N 8466 N610JSListo Air LLC · San Antonio, TXBuilt 2024 · S/N 9583 N610SFReach Air Medical Services LLC · Mcclellan, CABuilt 2011 · S/N 7278 N612RXTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 8615 N613RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2021 · S/N 8920 N613TCT A F Y Consulting · Bristow, VABuilt 2012 · S/N 7522 N614HHSky High Leasing LLC · Montrose, COBuilt 2016 · S/N 8305 N614JCKnight Helo LLC · Wilmington, DES/N 760694 N614RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2021 · S/N 8873 N614TCTafy Consulting · Bristow, VABuilt 2012 · S/N 7479 N615GRReach Air Medical Services LLC · Lewisville, TXBuilt 2025 · S/N 9820 N617CDOklahoma II LLC · Sandy, UTBuilt 2012 · S/N 7540 N617GCGranite Coast Mapping · Coronado, CABuilt 2009 · S/N 4676 N619GESan Diego Gas & Electric Co · San Diego, CABuilt 2017 · S/N 20156 N61RXReach Air Medical Services LLC · Mcclellan, CABuilt 2016 · S/N 8262 N61WLCorpat Inc · Missoula, MTBuilt 2013 · S/N 7752 N6211Department Of Homeland Security · Washington, DCBuilt 2021 · S/N 8972 N621FBCity Of Phoenix · Phoenix, AZBuilt 2022 · S/N 9127 N6227Austin Police Dept · Pflugerville, TXBuilt 2013 · S/N 7544 N622FBCity Of Phoenix · Phoenix, AZBuilt 2022 · S/N 9136 N623FBCity Of Phoenix · Phoenix, AZBuilt 2022 · S/N 9235 N623PDCoastal Helicopters LLC · La Vern, CABuilt 2014 · S/N 7894 N624FBCity Of Phoenix · Phoenix, AZBuilt 2023 · S/N 9291 N625FBCity Of Phoenix · Phoenix, AZBuilt 2023 · S/N 9365 N629AMAir Methods LLC · Greenwood Village, COBuilt 2005 · S/N 3941 N62ARBird Dog Aircraft LLC · Billings, MTBuilt 2006 · S/N 4175 N62RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2015 · S/N 8032

Back to AD 2016-25-13