Skip to content

AD 2018-01-12 R1

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.

N168BHBhi Holdings #1 LLC · Ontario, ORBuilt 2018 · S/N 8613 N16NSNs Air Leasing LLC · Wilmington, DES/N 7383 N172AEUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 3839 N173BHBhh Leasing #4 LLC · Pensacola, FLBuilt 2009 · S/N 4614 N174AHAres Air LLC · Phoenix, AZBuilt 2022 · S/N 9121 N175SCSeminole County Sheriffs Office · Sanford, FLBuilt 2017 · S/N 8430 N176SCSeminole County Sheriffs Office · Sanford, FLBuilt 2024 · S/N 9495 N179AAirbus Helicopters Inc · Grand Prairie, TXS/N 9996 N180QDepartment Of Homeland Security · Washington, DCBuilt 2020 · S/N 8815 N181PLAlpine Air Alaska LLC · Girdwood, AKBuilt 2014 · S/N 7812 N183AEU S Dept Of Homeland Security · Washington, DCS/N 3852 N183SDOrange County Sheriff'S Department · Costa Mesa, CABuilt 2017 · S/N 8376 N184RDepartment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9158 N185SDOrange County Sheriff'S Department · Costa Mesa, CABuilt 2016 · S/N 8125 N186AEUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 3872 N187AEUS Department Of Homeland Security · Washington, DCBuilt 2004 · S/N 3846 N188EULashinski Robert D Trustee · Sebastopol, CABuilt 2011 · S/N 7188 N191NRMaryland Natural Resources Police · Stevensville, MDBuilt 2023 · S/N 9382 N191TXTexas Dept Of Public Safety · Austin, TXBuilt 2010 · S/N 4841 N192ADepartment Of Homeland Security · Washington, DCBuilt 2011 · S/N 7184 N194AETemsco Helicopters Inc · Ketchikan, AKBuilt 2001 · S/N 3338 N1964LDepartment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9179 N1977GDepartment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9192 N198AETemsco Helicopters Inc · Ketchikan, AKBuilt 2001 · S/N 3371 N1997GAirbus Helicopters Inc · Grand Prairie, TXS/N 9970 N1CRComanche Maverick Air LLC · Houston, TXBuilt 2016 · S/N 8165 N1MZA Star 350 LLC · Henderson, NVS/N 7300 N203ZDepartment Of Homeland Security · Washington, DCBuilt 2020 · S/N 8811 N20AHAirbus Helicopters Inc · Grand Prairie, TXBuilt 2025 · S/N 9714 N2108JDeparment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9200 N211LAAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9910 N212KPitch Link LLC · New York, NYBuilt 2010 · S/N 7030 N212LAAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9919 N213PFLapd Air Support Division · Los Angeles, CABuilt 2017 · S/N 8340 N215GHBase Camp Aviation LLC · Mccall, IDBuilt 1998 · S/N 3147 N2171CNs Air Leasing LLC · Wilmington, DEBuilt 2001 · S/N 3427 N217HPNs Air Leasing LLC · Wilmington, DEBuilt 2002 · S/N 3628 N218SHSuperior Helicopter Services LLC · Indianapolis, INBuilt 2018 · S/N 8458 N21FYH125 Aviation LLC · Wailea, HIBuilt 2024 · S/N 9465 N221LALapd Air Support Division · Los Angeles, CABuilt 2014 · S/N 7900 N221MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 8680 N221PAFa Aviation Logistics Inc · Houston, TXBuilt 2014 · S/N 7851 N223LALapd Air Support Division · Los Angeles, CABuilt 2014 · S/N 7956 N223MTMed-Trans Corp · Denton, TXBuilt 2019 · S/N 8659 N224LALapd Air Support Division · Los Angeles, CABuilt 2022 · S/N 9185 N224MTMed-Trans Corp · Denton, TXBuilt 2022 · S/N 9221 N225LALapd Air Support Division · Los Angeles, CABuilt 2019 · S/N 8628 N226LALapd Air Support Division · Los Angeles, CABuilt 2019 · S/N 8636 N226MTLendingclub Bank Na · Boston, MABuilt 2019 · S/N 8671 N227MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 8892

Back to AD 2018-01-12 R1