Registered aircraft · 952

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.

N437AHRoberts Aircraft LLC · Cheyenne, WYBuilt 2017 · S/N 8419 N438MUMarshall University · Huntington, WVBuilt 2012 · S/N 7240 N43MJl Mark LLC · Missoula, MTS/N 8967 N43SDPinellas County Sheriffs Office · Largo, FLBuilt 2021 · S/N 9149 N43VPRoberts Aircraft LLC · Cheyenne, WYBuilt 2000 · S/N 3272 N447WAWallasch Aviation LLC · Alpine, WYBuilt 2023 · S/N 9447 N448AEShedhorn Construction Inc · Bozeman, MTBuilt 1999 · S/N 3210 N4497YAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 4497 N451FMayor And City Council Of Baltimore · Baltimore, MDBuilt 2022 · S/N 9250 N451HIsland Helicopters Kauai Inc · Lihue, HIBuilt 1999 · S/N 3231 N452FMayor And City Council Of Baltimore · Baltimore, MDBuilt 2022 · S/N 9293 N453FMayor And City Council Of Baltimore · Baltimore, MDBuilt 2023 · S/N 9317 N455GFAdventaire LLC · Minot, NDBuilt 2010 · S/N 4932 N456WXAirbus Helicopters Inc · Grand Prairie, TXS/N 9975 N461SAAir Twinlite Inc Trustee · Wilmington, DEBuilt 2002 · S/N 3605 N464RMRegional Air Medical Services Inc · Jasper, ALBuilt 2005 · S/N 3962 N472LALapd Air Support Division · Los Angeles, CABuilt 2018 · S/N 8472 N474RSLabell Aviation LLC · Spring Hill, FLS/N 9012 N479CDepartment Of Homeland Security · Washington, DCBuilt 2020 · S/N 8820 N47WHInternational Air Services Inc Trustee · Carson City, NVBuilt 2003 · S/N 3653 N487HBCounty Of Butte · Oroville, CABuilt 2020 · S/N 8886 N48BGazelle LLC · Missoula, MTS/N 1481 N490HAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 4539 N491LGAir Methods LLC · Greenwood Village, COBuilt 2018 · S/N 8553 N493LGTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 8764 N494LGManufacturers And Traders Trust Company · Bridgeport, CTBuilt 2019 · S/N 8750 N496LGAir Methods LLC · Greenwood Village, COBuilt 2018 · S/N 8582 N498AEPhi Health LLC · Tempe, AZBuilt 2003 · S/N 3687 N4AKAris Aviation Group LLC · Boulder City, NVS/N 2544 N4PAPylon Aviation Services LLC · Chandler, AZBuilt 2005 · S/N 3920 N500KVPortland General Electric Co · Portland, ORBuilt 2008 · S/N 4638 N502LMLouisville/Jefferson County Metro Government · Louisville, KYBuilt 2024 · S/N 9510 N503PHCity Of Miami Police Department · Miami, FLBuilt 2015 · S/N 8089 N507AMAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 4711 N508AMAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 4682 N509DRMaverick Air LLC · Deer Park, WABuilt 2014 · S/N 7887 N50NTCity On Ontario · Upland, CABuilt 2023 · S/N 9433 N511SCSabercat Productions LLC · Scottsdale, AZBuilt 2008 · S/N 4360 N5125N5125 LLC · North Las Vegas, NVBuilt 2017 · S/N 8381 N514FWOffice Of Aviation Services · Boise, IDBuilt 2023 · S/N 9339 N517MCPasco County Mosquito Control District · Odessa, FLBuilt 2020 · S/N 8805 N518MCPasco County Mosquito Control District · Odessa, FLBuilt 2020 · S/N 8814 N518MFCoastal Helicopters Inc · Juneau, AKBuilt 2012 · S/N 7436 N519FFSky High Leasing LLC · Montrose, COBuilt 2014 · S/N 7924 N5202YU S Dept Of Homeland Security · Washington, DCBuilt 1998 · S/N 3085 N5204GU S Dept Of Homeland Security · Washington, DCBuilt 1998 · S/N 3089 N5204PU S Dept Of Homeland Security · Washington, DCBuilt 1998 · S/N 3121 N520AHBering Air Inc · Nome, AKBuilt 2018 · S/N 8607 N521Airbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9942 N5230JSundance Helicopters Inc · Las Vegas, NVBuilt 1999 · S/N 3256

Back to AD 85-14-06 R1