Registered aircraft · 1,084

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.

N122AHNorton Basin Services · Nome, AKBuilt 2023 · S/N 9509 N125APAustin Police Dept · Pflugerville, TXBuilt 2022 · S/N 9282 N125CLHillsboro Aviation Inc · Hillsboro, ORBuilt 2015 · S/N 7987 N125DAPayne David L Trustee · Saint Louis, MOBuilt 2022 · S/N 9154 N125EPEnbridge Energy Co Inc · Houston, TXBuilt 2019 · S/N 8650 N125NBCisco Aero LLC · Grass Range, MTBuilt 2022 · S/N 9318 N125NYOffice Of Vector Surveillance And Control · New York, NYBuilt 2019 · S/N 8745 N125PDCity Of Albuquerque · Albuquerque, NMBuilt 2019 · S/N 8667 N126BHBhi Holdings #2 LLC · Ontario, ORBuilt 2012 · S/N 7403 N126PJHelibro LLC · Red Bluff, CABuilt 2010 · S/N 7039 N127BHBhi Holdings #3 LLC · Ontario, ORBuilt 2013 · S/N 7675 N127CHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 8189 N127PJHelibro LLC · Red Bluff, CABuilt 2011 · S/N 7180 N129NBPathfinder Leasing LLC · Anchorage, AKBuilt 2017 · S/N 8397 N12NYNew York Aircam Corp · Woodbury, NYBuilt 2018 · S/N 8594 N130Red Skies LLC · Kalispell, MTBuilt 2014 · S/N 8019 N1302TTemsco Helicopters Inc · Ketchikan, AKBuilt 2016 · S/N 8258 N1303TTemsco Helicopters Inc · Ketchikan, AKBuilt 2016 · S/N 8260 N1308Tvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2007 · S/N 760667 N1308TNs Air Leasing LLC · Wilmington, DEBuilt 2016 · S/N 8193 N1309TNs Air Leasing LLC · Wilmington, DEBuilt 2016 · S/N 8215 N130BUOhio Medical Transportation Inc · Columbus, OHBuilt 2011 · S/N 7132 N130CLOhio Medical Transportation Inc · Columbus, OHBuilt 2012 · S/N 7499 N130CRRomana Aircraft Inc · High Point, NCBuilt 2007 · S/N 4271 N130CSIndiana Helicopters LLC · Fort Wayne, INBuilt 2013 · S/N 7660 N130CZOrbic Air LLC · Burbank, CABuilt 2006 · S/N 4060 N130EEBuckeye Leasing LLC · Shreveport, LABuilt 2011 · S/N 7190 N130GBBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8742 N130GCMonarch Enterprises Inc · Kirkland, WABuilt 2002 · S/N 3562 N130GMBank Of Utah Trustee · Salt Lake City, UTBuilt 2009 · S/N 4837 N130HBOhio Medical Transportation Inc · Columbus, OHBuilt 2011 · S/N 7167 N130JVOhio Medical Transportation Inc · Columbus, OHBuilt 2012 · S/N 7490 N130KHOhio Medical Transportation Inc · Columbus, OHBuilt 2011 · S/N 7142 N130KJJackson Family Wines Inc · Santa Rosa, CABuilt 2004 · S/N 3873 N130KRAir Methods LLC · Greenwood Village, COBuilt 2012 · S/N 7317 N130LHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 4017 N130LLEffort Aviation LLC · Wilmington, DEBuilt 2012 · S/N 7375 N130MDEc 130 II LLC · Sterling, VABuilt 2012 · S/N 7549 N130MUOhio Medical Transportation Inc · Columbus, OHBuilt 2011 · S/N 7103 N130NBBuckeye Leasing LLC · Shreveport, LABuilt 2011 · S/N 7221 N130NWOhio Medical Transportation Inc · Columbus, OHBuilt 2011 · S/N 7182 N130PFOrlando Helicopter Partners LLC · Orlando, FLBuilt 2009 · S/N 4760 N130SBZorba130 LLC · Sparta, MIBuilt 2018 · S/N 8649 N130SMInternational Air Services Inc Trustee · Carson City, NVBuilt 2007 · S/N 4276 N130WSWorld Trade Enterprises LLC · Lucas, TXBuilt 2003 · S/N 3735 N1314TNs Air Leasing LLC · Wilmington, DEBuilt 2016 · S/N 8217 N131GCRainier Heli International Inc · Kirkland, WABuilt 2003 · S/N 3691 N131TLSummit130 LLC · Highland, UTBuilt 2016 · S/N 8254 N132BHBrainerd Helicopters Inc · Leesburg, FLBuilt 2007 · S/N 4374 N132GCAmerican Helicopters LLC · Kirkland, WABuilt 2003 · S/N 3756

Back to AD 2016-25-13