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.

N831HAHollywoods Astar LLC · Long Beach, CABuilt 2012 · S/N 7334 N831SBSan Bernardino County Sheriffs Dept · San Bernardino, CABuilt 2018 · S/N 8492 N832GCZuni LLC · Kirkland, WABuilt 2013 · S/N 7667 N832SBSan Bernardino County Sheriff'S Dept · San Bernardino, CABuilt 2018 · S/N 8487 N833GCXebec LLC · Kirkland, WABuilt 2013 · S/N 7747 N833SBSan Bernardino County Sheriffs Dept · San Bernardino, CABuilt 2017 · S/N 8435 N834GCAmerican Helicopters LLC · Kirkland, WABuilt 2014 · S/N 7829 N834PARogers Helicopters Inc · Fresno, CABuilt 2012 · S/N 7415 N834SBSan Bernardino County Sheriff'S Dept · San Bernardino, CABuilt 2017 · S/N 8389 N835GCZuni LLC · Kirkland, WABuilt 2014 · S/N 7833 N835PAXebec LLC · Kirkland, WABuilt 2012 · S/N 7501 N835SBSan Bernardino County Sheriffs Dept · San Bernardino, CABuilt 2016 · S/N 8221 N836GCMonarch Enterprises Inc · Kirkland, WABuilt 2014 · S/N 8012 N836PAAmerican Helicopters LLC · Kirkland, WABuilt 2012 · S/N 7508 N836SBSan Bernardino County Sheriffs Dept · San Bernardino, CABuilt 2016 · S/N 8233 N837GCMonarch Enterprises Inc · Kirkland, WABuilt 2008 · S/N 4637 N838PARainier Heli International Inc · Kirkland, WABuilt 2013 · S/N 7517 N841PARainier Heli International Inc · Kirkland, WABuilt 2013 · S/N 7748 N843LFLife Flight Network LLC · Aurora, ORBuilt 2018 · S/N 20219 N844BPUS Department Of Homeland Security · Washington, DCBuilt 2001 · S/N 3405 N844LFLife Flight Network LLC · Aurora, ORBuilt 2023 · S/N 21229 N844TXTexas Department Of Public Safety · Austin, TXBuilt 2019 · S/N 8761 N846MHMustang Leasing LLC · Henderson, NVBuilt 2007 · S/N 4248 N847BPUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3545 N847MHMustang Leasing LLC · Henderson, NVBuilt 2007 · S/N 4266 N848MHMustang Leasing LLC · Henderson, NVBuilt 2007 · S/N 4290 N849BPUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3554 N849MHMustang Leasing LLC · Henderson, NVBuilt 2007 · S/N 4313 N849NPMetropolitan Nashville Police · Nashville, TNBuilt 2022 · S/N 9160 N849PBArrow Aviation Co LLC · Broussard, LAS/N 760652 N850BPUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3584 N850MHMustang Leasing LLC · Henderson, NVBuilt 2007 · S/N 4327 N851MBMed-Trans Corp · Denton, TXBuilt 2011 · S/N 7236 N851MHMustang Leasing LLC · Henderson, NVBuilt 2007 · S/N 4340 N852MHMustang Leasing LLC · Henderson, NVBuilt 2007 · S/N 4356 N853BPUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3595 N853MBMed-Trans Corp · Denton, TXBuilt 2012 · S/N 7294 N853MHMustang Leasing LLC · Henderson, NVBuilt 2008 · S/N 4417 N854BPUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3598 N854MBReach Air Medical Services LLC · Santa Rosa, CABuilt 2012 · S/N 7474 N854MHMustang Leasing LLC · Henderson, NVBuilt 2008 · S/N 4433 N855CHAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 8055 N855MBMed-Trans Corp · Denton, TXBuilt 2013 · S/N 7523 N855PANs Air Leasing LLC · Wilmington, DEBuilt 2000 · S/N 3304 N856HWHaynes Aviation LLC · Wetumpka, ALBuilt 2010 · S/N 4908 N856MBMed Trans Corp · Denton, TXBuilt 2013 · S/N 7611 N856MHMustang Leasing LLC · Henderson, NVBuilt 2008 · S/N 4437 N857HWMed-Trans Corp · Denton, TXBuilt 2016 · S/N 8309 N857MBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 7615 N857MHMustang Leasing LLC · Henderson, NVBuilt 2008 · S/N 4457

Back to AD 2016-25-13