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.

N225LALapd Air Support Division · Los Angeles, CAFirst renewal noticeBuilt 2019 · S/N 8628 N226LALapd Air Support Division · Los Angeles, CAFirst renewal noticeBuilt 2019 · S/N 8636 N226MTLendingclub Bank Na · Boston, MABuilt 2019 · S/N 8671 N226PDAnaheim Police Dept · Fullerton, CABuilt 2004 · S/N 3879 N227MTTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 8892 N227NDHillsborough County Sheriff · Tampa, FLBuilt 2022 · S/N 9296 N227TXTexas Department Of Public Safety · Austin, TXBuilt 2025 · S/N 9786 N228LACity Of Los Angeles · Los Angeles, CABuilt 2000 · S/N 3316 N229AHMiller Jason · Scottsdale, AZBuilt 2023 · S/N 9353 N229LACity Of Los Angeles · Los Angeles, CABuilt 2000 · S/N 3317 N229MTMed-Trans Corp · Denton, TXBuilt 2022 · S/N 9203 N230AHAir Methods LLC · Greenwood Village, COBuilt 2024 · S/N 9674 N230LALapd Air Support Division · Los Angeles, CABuilt 2020 · S/N 8794 N232LACity Of Los Angeles · Los Angeles, CABuilt 2023 · S/N 9298 N232SHJc Aircraft Leasing LLC · Wasilla, AKS/N 7850 N233LACity Of Los Angeles · Los Angeles, CABuilt 2024 · S/N 9428 N233PAComanche Maverick Air LLC · Houston, TXBuilt 2018 · S/N 8507 N234BHBrainerd Helicopters Inc · Leesburg, FLBuilt 2012 · S/N 7398 N234BUHeli-USA Corp · Houston, TXS/N 1210 N2374FTexas Department Of Public Safety · Austin, TXBuilt 2020 · S/N 8817 N237BSSky High Leasing LLC · Montrose, COBuilt 2013 · S/N 7542 N239AHAirbus Helicopters Inc · Grand Prairie, TXBuilt 2023 · S/N 9386 N23HSVertical Corp · Kalispell, MTBuilt 2013 · S/N 7550 N242ADepartment Of Homeland Security · Washington, DCBuilt 2011 · S/N 7176 N243GCGranite Coast Mapping · Coronado, CABuilt 2009 · S/N 4617 N244CPAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2010 · S/N 7036 N244TXBrenthel Industries LLC · Helena, MTBuilt 2008 · S/N 4408 N249AHAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9878 N250AMAir Methods LLC · Greenwood Village, COBuilt 2025 · S/N 9741 N251HIsland Helicopters Kauai Inc · Lihue, HIBuilt 2005 · S/N 3975 N252CHCoastal Helicopters Inc · Juneau, AKBuilt 1996 · S/N 2954 N253AHAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9973 N253CHCoastal Helicopters Inc · Juneau, AKBuilt 1997 · S/N 2974 N253LFAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7158 N255LFAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7140 N255PJArk Aviation LLC · Central City, KYBuilt 2018 · S/N 8595 N257AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7203 N261AWAll Wool Aviation LLC · Coral Gables, FLBuilt 2014 · S/N 7869 N261NDepartment Of Homeland Security · Washington, DCBuilt 2021 · S/N 8916 N262TWRegistered aircraftBuilt 2012 · S/N 7333 N2658Department Of Homeland Security · Washington, DCBuilt 2021 · S/N 8959 N267ADepartment Of Homeland Security · Washington, DCS/N 7222 N267AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7215 N267LALapd Air Support Division · Los Angeles, CABuilt 2017 · S/N 8267 N268JAirbus Helicopters Inc · Grand Prairie, TXS/N 9916 N26HXNs Air Leasing LLC · Wilmington, DEBuilt 2007 · S/N 4385 N270PWTexas Parks And Wildlife Department · Austin, TXBuilt 2023 · S/N 9374 N274CHWalker Kenneth E · Ford City, PABuilt 1989 · S/N 2306 N275BPCity Of Burbank · Burbank, CAS/N 1930 N2770KAirbus Helicopters Inc · Grand Prairie, TXNon-citizen corporation, flight hours not reportedS/N 9854

Back to AD 2012-25-01