Registered aircraft · 954

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:2012-25-01') OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-25-01') 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:2012-25-01')
    OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-25-01')
  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:2012-25-01')
  OR engine_model_code IN (SELECT engine_model_code FROM 'https://openairdocs.org/data/latest/faa_engine_model_directive.parquet' WHERE ad_id = 'FAA:2012-25-01')
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.

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 N193BHBlack Mountain Aviation LLC · Boulder City, NVBuilt 1995 · S/N 2894 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 N197BHNevada Helicopter Leasing LLC · Greenwood Village, COBuilt 1992 · S/N 2666 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 N1SDPinellas County Sheriffs Office · Clearwater, FLBuilt 2015 · S/N 8024 N202SCNs Air Leasing LLC · Wilmington, DEBuilt 1982 · S/N 5204 N203CHCoastal Helicopters Inc · Juneau, AKBuilt 1981 · S/N 1430 N203ZDepartment Of Homeland Security · Washington, DCBuilt 2020 · S/N 8811 N204CHCoastal Helicopters · Juneau, AKBuilt 1981 · S/N 2054 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 N2127SEurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 1989 · S/N 2213 N212CMAerospace Trust Management LLC Trustee · Wilmington, DES/N 2232 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 N214EHBristow LLC · Lake Charles, LABuilt 1998 · S/N 3163 N214GHCobalt Holdings Inc · Pacoima, CABuilt 1991 · S/N 2537 N214STBank Of Utah Trustee · Salt Lake City, UTS/N 2141 N215EHBristow LLC · Lake Charles, LABuilt 1998 · S/N 3172 N215GHBase Camp Aviation LLC · Mccall, IDBuilt 1998 · S/N 3147 N216CHCoastal Helicopters Inc · Juneau, AKBuilt 2002 · S/N 3619 N216EHBristow LLC · Lake Charles, LABuilt 1999 · S/N 3184 N2171CNs Air Leasing LLC · Wilmington, DEBuilt 2001 · S/N 3427 N217EHBristow LLC · Lake Charles, LABuilt 1999 · S/N 3197 N217FDBristow LLC · Lake Charles, LABuilt 2007 · S/N 4221 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 N220CFMercy Air Helicopter Inc · Fort Lauderdale, FLBuilt 2001 · S/N 3411 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

Back to AD 2012-25-01