Skip to content

Registered aircraft · 308

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-08-20') 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-08-20') 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-08-20')
    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-08-20')
  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-08-20')
  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-08-20')
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.

N106GRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2024 · S/N 9634 N106VUAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 7996 N109GRAir Evac Ems Inc · O Fallon, MOBuilt 2024 · S/N 9650 N113EVFly Hangar 13 LLC · Mico, TXS/N 3764 N114GRReach Air Medical Services LLC · Santa Rosa, CABuilt 2025 · S/N 9818 N11EQNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2012 · S/N 7485 N11FQAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 7571 N11KQAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 7723 N11MQNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2014 · S/N 7879 N11NQNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2014 · S/N 7950 N11QANevada Helicopter Leasing LLC · Greenwoodvillage, COBuilt 2004 · S/N 3887 N11QCNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2001 · S/N 3358 N11QFNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2002 · S/N 3482 N11QGNevada Helicopter Leasing LLC · Greenwood Village, COS/N 3534 N11QHNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2002 · S/N 3561 N11QJNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2008 · S/N 4528 N11QKNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2002 · S/N 3639 N11QLNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2003 · S/N 3738 N11QMNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2003 · S/N 3751 N11QNNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2003 · S/N 3758 N11QPNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2009 · S/N 4715 N11QRNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2005 · S/N 3992 N11QUNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2009 · S/N 4758 N11QWNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2010 · S/N 4929 N11QXNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2011 · S/N 7198 N11QYNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2011 · S/N 7229 N11QZNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2008 · S/N 4663 N11TQNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 2014 · S/N 8044 N11UQAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 8053 N11XQAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 8113 N11YQAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 8156 N123RTMather Air LLC · Paris, KYBuilt 2004 · S/N 3841 N127CHTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 8189 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 N1308TNs Air Leasing LLC · Wilmington, DEBuilt 2016 · S/N 8193 N1309TNs Air Leasing LLC · Wilmington, DEBuilt 2016 · S/N 8215 N130ADEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 3515 N130AHHelio Helicopter Co LLC · Manchester, NHS/N 3862 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

Back to AD 2016-08-20