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:86-15-10-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:86-15-10-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:86-15-10-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:86-15-10-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:86-15-10-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:86-15-10-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.

N818HAHelinet Aviation Services LLC · Van Nuys, CABuilt 2005 · S/N 3901 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

Back to AD 86-15-10 R1