Registered aircraft · 953

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:85-14-06-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:85-14-06-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:85-14-06-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:85-14-06-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:85-14-06-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:85-14-06-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.

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 N955HDTurbolyft USA Corp · Pitt Meadows BcNon-citizen corporation, flight hours not reportedBuilt 1984 · S/N 1596

Back to AD 85-14-06 R1