Skip to content

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.

N955LACounty Of Los Angeles · Long Beach, CABuilt 2010 · S/N 7018 N956LACounty Of Los Angeles · Long Beach, CABuilt 2010 · S/N 7047 N957LACounty Of Los Angeles · Long Beach, CABuilt 2010 · S/N 7072 N958LACounty Of Los Angeles · Long Beach, CABuilt 2010 · S/N 7085 N959LACounty Of Los Angeles · Long Beach, CAS/N 7092 N960LACounty Of Los Angeles · Long Beach, CAS/N 7120 N961LACounty Of Los Angeles · Long Beach, CAS/N 7129 N961SDCounty Of Los Angeles Sheriffs Department · Long Beach, CABuilt 2001 · S/N 3516 N962LACounty Of Los Angeles · Long Beach, CAS/N 7009 N963ESFast Helicopters Inc Trustee · Wilmington, DEBuilt 1979 · S/N 1089 N963SDCounty Of Los Angeles · Long Beach, CABuilt 2002 · S/N 3579 N964SASaf Ltd · Lihue, HIBuilt 1996 · S/N 2931 N966FSTumbleweed Leasing Co Inc · West Jordan, UTBuilt 1989 · S/N 2301 N966SDCounty Of Los Angeles · Long Beach, CABuilt 2003 · S/N 3637 N969Box Family Aviation LLC · Denver, COBuilt 2024 · S/N 9670 N970AEPhi Health LLC · Tempe, AZBuilt 1999 · S/N 3235 N970JFAlouette LLC · Grand Junction, COBuilt 1988 · S/N 2101 N970THTemsco Helicopters Inc · Ketchican, AKS/N 9011 N970WEWest Elk Air LLC · Gunnison, COBuilt 2005 · S/N 4037 N973AEPhi Health LLC · Tempe, AZBuilt 1999 · S/N 3229 N974HPCalifornia Highway Patrol · Sacramento, CABuilt 2014 · S/N 7871 N975HPCalifornia Highway Patrol · Sacramento, CABuilt 2014 · S/N 7873 N975MMStuckey Connections LLC · Magnolia, TXBuilt 2007 · S/N 4195 N976HPCalifornia Highway Patrol · Sacramento, CABuilt 2014 · S/N 7881 N978HPCalifornia Highway Patrol · Sacramento, CABuilt 2014 · S/N 7915 N979HPCalifornia Highway Patrol Office Of Air Operations · Sacramento, CABuilt 2014 · S/N 7918 N980MHRegistered aircraftBuilt 2022 · S/N 9108 N981DWRaven Aviation LLC · Fresno, CABuilt 2015 · S/N 8132 N981HPCalifornia Highway Patrol · Sacramento, CABuilt 2016 · S/N 8169 N981TXAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9933 N982BHBlack Mountain Aviation LLC · Boulder City, NVBuilt 1995 · S/N 2876 N982HPCalifornia Highway Patrol · Sacramento, CABuilt 2016 · S/N 8187 N983HPCalifornia Highway Patrol · Sacramento, CABuilt 2016 · S/N 8190 N984HPCalifornia Highway Patrol · Sacramento, CABuilt 2019 · S/N 8653 N985HPCalifornia Highway Patrol · Sacramento, CABuilt 2019 · S/N 8666 N986HPCalifornia Highway Patrol · Sacramento, CABuilt 2023 · S/N 9394 N988HPCalifornia Highway Patrol · Sacramento, CABuilt 2021 · S/N 8927 N988MDMarine 1 LLC · Westport, CTBuilt 2019 · S/N 8686 N992SDCounty Of Riverside · Hemet, CAS/N 3319 N993SDCounty Of Riverside California · Hemet, CAS/N 4045 N994SDCounty Of Riverside California · Hemet, CABuilt 2007 · S/N 4240 N99523Ns Air Leasing LLC · Wilmington, DEBuilt 2001 · S/N 3461 N995ASAog-Thurd Ferguson LLC · Corpus Christi, TXS/N 4138 N995BCBrevard County Board Of County Commissioners · Titusville, FLBuilt 2013 · S/N 7556 N99676Alpine Air Alaska LLC · Girdwood, AKBuilt 1982 · S/N 1542 N996PDTwin Peaks Aviation LLC · Missoula, MTBuilt 1998 · S/N 3168 N996RSRiverside County Sheriffs Department · Hemet, CABuilt 2024 · S/N 9569 N997SDCounty Of Riverside California · Hemet, CABuilt 2014 · S/N 7949 N998NPAviation Trust Company LLC Trustee · Oklahoma City, OKBuilt 2013 · S/N 7697 N998SDCounty Of Riverside California · Hemet, CABuilt 2014 · S/N 7952

Back to AD 85-14-06 R1