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.

N526RBPalm Beach County Sheriffs Office · West Palm Beach, FLBuilt 2021 · S/N 57427 N529AMLendingclub Bank Na · Boston, MABuilt 2019 · S/N 57375 N529LECollier County Sheriffs Office · Naples, FLBuilt 2021 · S/N 57435 N52HXHelicopter Express LLC · Chamblee, GABuilt 2010 · S/N 57026 N535TBEuroaviation Inc Trustee · KematenBuilt 2014 · S/N 57213 N556BHBell Textron Inc · Fort Worth, TXBuilt 2025 · S/N 57556 N557BHBell Textron Inc · Fort Worth, TXBuilt 2026 · S/N 57558 N572MRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 57207 N574FBFbr Aviation Inc · Fort Lauderdale, FLBuilt 2021 · S/N 57424 N579BTBell Textron Inc · Fort Worth, TXS/N 57579 N5AZJetco LLC · Kalamazoo, MIBuilt 2022 · S/N 57468 N604PDNassau County Police Department · Bethpage, NYBuilt 2015 · S/N 57252 N606PDNassau County Police Department · Bethpage, NYBuilt 2015 · S/N 57253 N60SMRegistered aircraftN-number assigned (import), not yet registeredS/N 57224 N611NBCisco Aero LLC · Cisco, TXBuilt 2012 · S/N 57072 N665PVCedar Knoll Vineyards Inc DBA Palmaz Vineyards · Napa, CABuilt 2015 · S/N 57271 N667KMEuroaviation Inc Trustee · KematenBuilt 2020 · S/N 57410 N673CPHigh Hills LLC · Clinton, NCBuilt 2013 · S/N 57167 N6SPState Of Delaware · Dover, DEBuilt 2019 · S/N 57366 N702ACTcp One LLC · Amarillo, TXBuilt 2012 · S/N 57085 N705WPCity Of Los Angeles Dept Of Water & Power · Van Nuys, CABuilt 2023 · S/N 57487 N706WPCity Of Los Angeles Department Of Water & Power · Van Nuys, CABuilt 2023 · S/N 57488 N70ADRegistered aircraftS/N 57449 N712SLAir Methods LLC · Greenwood Village, COBuilt 2019 · S/N 57374 N713NGNiagara Mohawk Power Corp DBA · Syracuse, NYBuilt 2014 · S/N 57219 N717SPMinnesota State Patrol · Saint Paul, MNBuilt 2024 · S/N 57515 N71SPState Of Delaware · Middletown, DEBuilt 2024 · S/N 57510 N7331GTotal Helicopters Unlimited · Stafford, VABuilt 2021 · S/N 57442 N753SLVentus Mf LLC · Boise, IDS/N 57305 N755SLVentus Mf LLC · Boise, IDBuilt 2016 · S/N 57307 N767PDAdministracion De Servicios Generales · San Juan, PRBuilt 2024 · S/N 57530 N772UTUnited Therapeutics Corp · Res Triangle Park, NCBuilt 2012 · S/N 57101 N780HPTennessee Department Of Safety & Homeland Security · Nashville, TNS/N 57335 N781ACWintrust Asset Finance Inc · Frisco, TXBuilt 2021 · S/N 57440 N783AZState Of Arizona Department Of Public Safety · Phoenix, AZBuilt 2022 · S/N 57462 N78UTUnited Therapeutics Corp · Silver Spring, MDBuilt 2018 · S/N 57322 N790HPTennessee Department Of Safety & Homeland Security · Nashville, TNBuilt 2024 · S/N 57519 N795RBPalm Beach County Sheriffs Office · West Palm Beach, FLBuilt 2019 · S/N 57382 N808MBMarbina Interests Office LLC · Satellite Beach, FLBuilt 2013 · S/N 57150 N80KGBell Textron Inc · Fort Worth, TXS/N 57565 N812LEMaricopa County · Phoenix, AZBuilt 2020 · S/N 57397 N822AZArizona Department Of Public Safety · Phoenix, AZS/N 57439 N861NCAir Methods LLC · Greenwood Village, COBuilt 2014 · S/N 57239 N862NCKeybank National Association · Superior, COBuilt 2014 · S/N 57242 N87SJAir Biggie LLC · Bristol, VABuilt 2010 · S/N 57023 N88DWUS Trinity Equipment LLC · Argyle, TXBuilt 2014 · S/N 57247 N899NPNorthern Indiana Public Service Co LLC · Merrillville, INS/N 57477 N905WMValiair Lc Trustee · Casper, WYS/N 57347 N908KBWintrust Asset Finance Inc · Frisco, TXBuilt 2021 · S/N 57433 N911AMEstado Libre Asociado De Puerto Rico · San Juan, PRS/N 57284

Back to AD 2017-15-13