Skip to content

Registered aircraft · 146

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:2022-01-05') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2022-01-05') 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:2022-01-05')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2022-01-05')
  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:2022-01-05')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2022-01-05')
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 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 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 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 N130CSIndiana Helicopters LLC · Fort Wayne, INBuilt 2013 · S/N 7660 N130GBBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 8742 N130SBZorba130 LLC · Sparta, MIBuilt 2018 · S/N 8649 N130TPOmyhelli LLC · Saratoga Springs, UTS/N 8273 N1314TNs Air Leasing LLC · Wilmington, DEBuilt 2016 · S/N 8217 N131TLLink Snacks Inc · Hayward, WIBuilt 2016 · S/N 8254 N139JHNs Air Leasing LLC · Wilmington, DEBuilt 2018 · S/N 8596 N15AHSan Francisco Bay Heli LLC · San Francisco, CABuilt 2022 · S/N 9295 N165GRMed-Trans Corp · Denton, TXBuilt 2026 · S/N 9925 N190GRReach Air Medical Services LLC · Lewisville, TXBuilt 2026 · S/N 9909 N1958MMjb Investments LLC · Bellevue, WABuilt 2015 · S/N 8130 N195GRAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9974 N19NLWabel Brad · Boerne, TXBuilt 2018 · S/N 8593 N204WBAirbus Helicopters Inc · Grand Prairie, TXS/N 9965 N208SHAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 7644 N211LPHeliquest LLC · Greenville, SCBuilt 2015 · S/N 8181 N213SHAir Methods LLC · Greenwood Village, COBuilt 2013 · S/N 7651 N216AHBank Of Utah Owner Trustee · Salt Lake City, UTBuilt 2024 · S/N 9665 N216SHAir Methods LLC · Greenwood Village, COS/N 7674 N222SHAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 7943 N223DECdv Se Properties LLC · Grand Rapids, MIBuilt 2019 · S/N 8693 N223SHAir Methods LLC · Greenwood Village, COS/N 7953 N22TZKestrel Holdings LLC · Portland, ORBuilt 2014 · S/N 8016 N230TJAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 7966 N231SHAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 7993 N237SHAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 8005 N239SHAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 8100 N240SHAir Methods LLC · Greenwood Village, COS/N 8105 N242SHAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 8120 N244SHAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 8157 N247KD130h LLC · Springville, UTBuilt 2013 · S/N 7758

Back to AD 2022-01-05