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.

N868MCLee County Mosquitto Control District · Lehigh Acres, FLBuilt 2018 · S/N 8448 N869MCLee County Mosquito Control District · Lehigh Acres, FLBuilt 2025 · S/N 9762 N86LJPc Sky Rotor LLC · Park City, UTBuilt 2021 · S/N 9126 N877XLRogers Helicopters Inc · Fresno, CABuilt 1999 · S/N 3194 N878XLRogers Helicopters Inc · Clovis, CABuilt 2014 · S/N 7791 N87GFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 8708 N87MYEast Baton Rouge Parish Mosquito · Baton Rouge, LABuilt 2024 · S/N 9422 N880GTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 7940 N881GTReach Air Medical Services LLC · Santa Rosa, CABuilt 2014 · S/N 7983 N881SDCity Of San Diego · San Diego, CABuilt 2019 · S/N 8778 N882GTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 7992 N882SDCity Of San Diego · San Diego, CABuilt 2024 · S/N 9553 N883GTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2015 · S/N 8001 N883SDCity Of San Diego · San Diego, CABuilt 2024 · S/N 9573 N884GTReach Air Medical Services LLC · Santa Rosa, CABuilt 2015 · S/N 8004 N884SDCity Of San Diego Police Air Support Unit · San Diego, CABuilt 2025 · S/N 9626 N886GTGuardian Flight LLC · South Jordan, UTBuilt 2015 · S/N 8091 N889AETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2010 · S/N 4959 N889GTGuardian Flight LLC · South Jordan, UTBuilt 2015 · S/N 8011 N893NDepartment Of Homeland Security · Washington, DCBuilt 2021 · S/N 8881 N895BCBrevard County Board Of County Commissioners · Titusville, FLBuilt 2013 · S/N 7554 N898JFState Of Montana · Helena, MTBuilt 2007 · S/N 4120 N8DTDt Equipment Leasing LLC · Ten Sleep, WYBuilt 2024 · S/N 9489 N901CFRegional Emergency Medical Services Authority · Reno, NVBuilt 2006 · S/N 4160 N901JBMartin County Sheriffs Office · Stuart, FLBuilt 2025 · S/N 9754 N901TPCity Of Tulsa · Tulsa, OKBuilt 2023 · S/N 9435 N902CFRegional Emergency Medical Services Authority · Reno, NVBuilt 2024 · S/N 9438 N903CFRegional Emergency Medical Svcs Authority (Remsa) · Reno, NVBuilt 2023 · S/N 9381 N903PAirbus Helicopters Inc · Grand Prairie, TXS/N 9892 N904CFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 8735 N907KDGci Communication Corp · Anchorage, AKBuilt 2024 · S/N 9680 N910LSTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2014 · S/N 7856 N91122Teton County Wyoming · Jackson, WYBuilt 2023 · S/N 9326 N911AAState Of Alaska · Anchorage, AKBuilt 2013 · S/N 7536 N911ASWashington Dc Metropolitan Police · Washington, DCS/N 3964 N911CVTemsco Helicopters Inc · Ketchikan, AKBuilt 1998 · S/N 3142 N911DCMayor And City Council Of Washington Dc · Washington, DCBuilt 2023 · S/N 9452 N911DGHillsborough County Sheriffs Office · Tampa, FLBuilt 2020 · S/N 8859 N911DSCounty Of Hawaii · Hilo, HIBuilt 2022 · S/N 9244 N911MQParkhursts Fly LLC · Newark, DEBuilt 2021 · S/N 9153 N911NQCharlotte County Sheriffs Office · Punta Gorda, FLBuilt 2011 · S/N 7299 N911NTState Of Alaska · Anchorage, AKBuilt 2013 · S/N 7665 N911RPCity Of Riverside · Riverside, CABuilt 2022 · S/N 9264 N911USFlagler County Florida · Bunnell, FLBuilt 2023 · S/N 9171 N911WLPlacer County Public Financing Authority · Auburn, CABuilt 2008 · S/N 4587 N911ZZBernalillo County Sheriff'S Dept · Albuquerque, NMS/N 4205 N912KCKern County Sheriffs Office · Bakersfield, CABuilt 2023 · S/N 9252 N913KCKern County Sheriffs Office · Bakersfield, CABuilt 2023 · S/N 9262 N913SMSisters Of Charity Of Leavenworth Health Systems · Grand Junction, COBuilt 2008 · S/N 4600 N914SMAir Methods LLC · Greenwood Village, COBuilt 2018 · S/N 8536

Back to AD 2018-01-12 R1