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.

N818HDUS Helicopters Inc · Marshville, NCBuilt 1990 · S/N 2376 N818PDCity Of Glendale · Glendale, CABuilt 2025 · S/N 9642 N819TXTexas Department Of Public Safety · Austin, TXBuilt 2012 · S/N 7287 N821PDEast Bay Regional Park District · Livermore, CABuilt 2021 · S/N 8914 N821SPAviation Concepts America LLC · Daytona Beach, FLBuilt 1988 · S/N 2106 N824TXTexas Department Of Public Safety · Austin, TXBuilt 2021 · S/N 9107 N826PDCity Of Anaheim · Fullerton, CABuilt 2006 · S/N 4191 N82769Ns Air Leasing LLC · Wilmington, DEBuilt 2013 · S/N 7718 N827NARoberts Aircraft LLC · Cheyenne, WYBuilt 1998 · S/N 3144 N827SDEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 1452 N827TXTexas Department Of Public Safety · Austin, TXS/N 9873 N828APHelinet Aviation Services LLC · Van Nuys, CABuilt 2011 · S/N 7237 N829TCBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 9614 N82LFGctpa · Waukesha, WIBuilt 1983 · S/N 5301 N830PANs Air Leasing LLC · Wilmington, DEBuilt 2014 · S/N 8029 N831HAHollywoods Astar LLC · Long Beach, CABuilt 2012 · S/N 7334 N831RBVertical Corporation Inc · Kalispell, MTS/N 4862 N831SBSan Bernardino County Sheriffs Dept · San Bernardino, CABuilt 2018 · S/N 8492 N832SBSan Bernardino County Sheriff'S Dept · San Bernardino, CABuilt 2018 · S/N 8487 N833SBSan Bernardino County Sheriffs Dept · San Bernardino, CABuilt 2017 · S/N 8435 N834PARogers Helicopters Inc · Fresno, CABuilt 2012 · S/N 7415 N834SBSan Bernardino County Sheriff'S Dept · San Bernardino, CABuilt 2017 · S/N 8389 N835PAXebec LLC · Kirkland, WABuilt 2012 · S/N 7501 N835SBSan Bernardino County Sheriffs Dept · San Bernardino, CABuilt 2016 · S/N 8221 N836PAAmerican Helicopters LLC · Kirkland, WABuilt 2012 · S/N 7508 N836SBSan Bernardino County Sheriffs Dept · San Bernardino, CABuilt 2016 · S/N 8233 N838PARainier Heli International Inc · Kirkland, WABuilt 2013 · S/N 7517 N841PARainier Heli International Inc · Kirkland, WABuilt 2013 · S/N 7748 N844BPUS Department Of Homeland Security · Washington, DCBuilt 2001 · S/N 3405 N844TXTexas Department Of Public Safety · Austin, TXBuilt 2019 · S/N 8761 N845BPUS Department Of Homeland Security · Washington, DCBuilt 2001 · S/N 3464 N846BPUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3542 N847BPUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3545 N848BPUS Department Of Homeland Security · Washington, DCS/N 3375 N849BPUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3554 N849NPMetropolitan Nashville Police · Nashville, TNBuilt 2022 · S/N 9160 N850BPUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3584 N851MBMed-Trans Corp · Denton, TXBuilt 2011 · S/N 7236 N853BPUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3595 N853MBMed-Trans Corp · Denton, TXBuilt 2012 · S/N 7294 N854BPUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3598 N854MBReach Air Medical Services LLC · Santa Rosa, CABuilt 2012 · S/N 7474 N855MBMed-Trans Corp · Denton, TXBuilt 2013 · S/N 7523 N855PANs Air Leasing LLC · Wilmington, DEBuilt 2000 · S/N 3304 N855SADcm Inventory LLC · Provo, UTS/N 3474 N856BPUS Department Of Homeland Security · Washington, DCBuilt 2002 · S/N 3617 N856HWHaynes Aviation LLC · Wetumpka, ALBuilt 2010 · S/N 4908 N856MBMed Trans Corp · Denton, TXBuilt 2013 · S/N 7611 N857MBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 7615 N858TTBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 9312

Back to AD 85-14-06 R1