Registered aircraft · 646

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:2018-01-12-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:2018-01-12-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:2018-01-12-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:2018-01-12-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:2018-01-12-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:2018-01-12-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.

N821PDEast Bay Regional Park District · Livermore, CABuilt 2021 · S/N 8914 N824TXTexas Department Of Public Safety · Austin, TXBuilt 2021 · S/N 9107 N82769Ns Air Leasing LLC · Wilmington, DEBuilt 2013 · S/N 7718 N827NARoberts Aircraft LLC · Cheyenne, WYBuilt 1998 · S/N 3144 N827TXTexas Department Of Public Safety · Austin, TXS/N 9873 N829TCBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 9614 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 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 N859MBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 7685 N860MBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 7729 N861MBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 7755 N862MBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2013 · S/N 7771 N863MBReach Air Medical Services LLC · Santa Rosa, CABuilt 2014 · S/N 7814 N864MBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 7820 N866MBTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 7826 N866MCLee County Mosquito Control Destrict · Lehigh Acres, FLBuilt 2017 · S/N 8436 N867MCLee County Mosquito Control District · Lehigh Acres, FLBuilt 2017 · S/N 8443

Back to AD 2018-01-12 R1