Registered aircraft · 954

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:2015-17-01-R1') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2015-17-01-R1') 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:2015-17-01-R1')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2015-17-01-R1')
  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:2015-17-01-R1')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2015-17-01-R1')
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.

N90DKDekalb County Police · Tucker, GABuilt 2004 · S/N 3807 N90TXTexas Department Of Public Safety · Austin, TXBuilt 2008 · S/N 4401 N910LSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 7856 N91122Teton County Wyoming · Jackson, WYBuilt 2023 · S/N 9326 N911AAState Of Alaska · Anchorage, AKBuilt 2013 · S/N 7536 N911ASWashington Dc Metropolitan Police · Washington, DCS/N 3964 N911CVTemsco Helicopters Inc · Ketchikan, AKBuilt 1998 · S/N 3142 N911DCMayor And City Council Of Washington Dc · Washington, DCBuilt 2023 · S/N 9452 N911DGHillsborough County Sheriffs Office · Tampa, FLBuilt 2020 · S/N 8859 N911DSCounty Of Hawaii · Hilo, HIBuilt 2022 · S/N 9244 N911MQParkhursts Fly LLC · Newark, DEBuilt 2021 · S/N 9153 N911NQCharlotte County Sheriffs Office · Punta Gorda, FLBuilt 2011 · S/N 7299 N911NTState Of Alaska · Anchorage, AKBuilt 2013 · S/N 7665 N911RPCity Of Riverside · Riverside, CABuilt 2022 · S/N 9264 N911USFlagler County Florida · Bunnell, FLBuilt 2023 · S/N 9171 N911WLPlacer County Public Financing Authority · Auburn, CABuilt 2008 · S/N 4587 N911ZZBernalillo County Sheriff'S Dept · Albuquerque, NMS/N 4205 N912KCKern County Sheriffs Office · Bakersfield, CABuilt 2023 · S/N 9252 N913KCKern County Sheriffs Office · Bakersfield, CABuilt 2023 · S/N 9262 N913SMSisters Of Charity Of Leavenworth Health Systems · Grand Junction, COBuilt 2008 · S/N 4600 N913WBLapd Air Support Division · Los Angeles, CABuilt 2008 · S/N 4491 N914SMAir Methods LLC · Greenwood Village, COBuilt 2018 · S/N 8536 N915HDUS Helicopters Inc · Marshville, NCBuilt 2002 · S/N 3583 N915MKato Aviation LLC · Henderson, MNBuilt 1987 · S/N 2020 N91DKDekalb Police Department · Tucker, GABuilt 2005 · S/N 3918 N91NSNs Air Leasing LLC · Wilmington, DEBuilt 2010 · S/N 7035 N921HMObsidian Aircraft LLC · Boise, IDBuilt 2015 · S/N 7981 N922BWRegistered aircraftN-number assigned (import), not yet registeredS/N 3337 N925TVTiny Bubbles Aviation Inc · Pacoima, CABuilt 2007 · S/N 4372 N927LBElt Holdings LLC · Cottonwood, AZBuilt 1990 · S/N 2347 N927MDepartment Of Homeland Security · Washington, DCBuilt 2020 · S/N 8791 N929EDepartment Of Homeland Security · Washington, DCBuilt 2023 · S/N 9344 N929NPMetro Nashville Police · Nashville, TNBuilt 2022 · S/N 9248 N929TXTexas Department Of Public Safety · Austin, TXBuilt 2025 · S/N 9812 N929WBAircraft Trustee Services Inc Trustee · Dover, DEBuilt 1990 · S/N 2335 N933HDUS Helicopters Inc · Marshville, NCBuilt 2013 · S/N 7799 N934EMTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2012 · S/N 7422 N936DMSoto Alex Medina · San Sebastian, PRBuilt 2009 · S/N 4712 N941EMReach Air Medical Services LLC · Santa Rosa, CABuilt 2014 · S/N 7854 N942AEZuni LLC · Kirkland, WABuilt 2014 · S/N 7865 N942EMReach Air Medical Services LLC · Santa Rosa, CABuilt 2014 · S/N 7844 N943AEBoeing Co · Mesa, AZBuilt 2014 · S/N 7870 N94RPAs350 LLC · Missoula, MTBuilt 2024 · S/N 9455 N950FSTumbleweed Leasing Company Inc · Salt Lake City, UTS/N 3083 N950LACounty Of Los Angeles · Long Beach, CABuilt 2010 · S/N 4930 N951LACounty Of Los Angeles · Long Beach, CABuilt 2010 · S/N 4933 N951RPCity Of Riverside · Riverside, CABuilt 2023 · S/N 9300 N953LACounty Of Los Angeles · Long Beach, CABuilt 2010 · S/N 4990 N954LACounty Of Los Angeles · Long Beach, CABuilt 2010 · S/N 4999 N955AHBering Air Inc · Nome, AKBuilt 2025 · S/N 9876

Back to AD 2015-17-01 R1