Registered aircraft · 175

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:2017-15-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:2017-15-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:2017-15-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:2017-15-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:2017-15-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:2017-15-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.

N911AZState Of Arizona · Phoenix, AZS/N 57301 N911DXAir Methods LLC · Greenwood Village, COBuilt 2019 · S/N 57377 N911EDAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 57006 N911JLJefferson Parish Sheriffs Office · Harvey, LABuilt 2012 · S/N 57096 N911KXLendingclub Bank Na · Boston, MABuilt 2011 · S/N 57002 N911NMSan Juan Regional Medical Center · Farmington, NMBuilt 2010 · S/N 57031 N911VHCook County Sheriff'S Office · Chicago, ILBuilt 2024 · S/N 57524 N911ZPCity Of Chicago Department Of Police · Chicago, ILBuilt 2024 · S/N 57505 N917PDNew York City Police Department · Brooklyn, NYBuilt 2013 · S/N 57148 N918PDNew York City Police Department · Brooklyn, NYBuilt 2014 · S/N 57188 N918TRExecutive Pl Solutions LLC · Salt Lake City, UTBuilt 2021 · S/N 57426 N919PDNew York City Police Department · Brooklyn, NYBuilt 2014 · S/N 57220 N920PDNew York City Police Department · Brooklyn, NYBuilt 2014 · S/N 57233 N922STSan Tomo Inc · Stockton, CABuilt 2014 · S/N 57206 N924SPGeorgia Dept Of Public Safety · Kennesaw, GABuilt 2013 · S/N 57151 N9306BKuwait International Aircraft Leasing Inc · Wilmington, DEBuilt 2022 · S/N 57453 N947TRBell Textron Inc · Fort Worth, TXS/N 57560 N961BHSierra Pacific Industries · Redding, CABuilt 2013 · S/N 57146 N965KTWilmington Trust Co Trustee · Wilmington, DEBuilt 2011 · S/N 57020 N965SPLouisiana State Police · Baton Rouge, LABuilt 2022 · S/N 57445 N967BKBlack Knight Aviation Services LLC · Whitefish, MTBuilt 2011 · S/N 57074 N983SVTotal Helicopters Unlimited · Stafford, VAS/N 57348 N988FYTotal Helicopters Unlimited · Stafford, VABuilt 2021 · S/N 57444 N997BFBank Of Utah Trustee · Salt Lake City, UTBuilt 2014 · S/N 57236 N9CRBanner Elk Aviation LLC · Banner Elk, NCBuilt 2013 · S/N 57149

Back to AD 2017-15-13