Skip to content

Registered aircraft · 1,085

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

N242ADepartment Of Homeland Security · Washington, DCBuilt 2011 · S/N 7176 N242SHAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 8120 N243GCGranite Coast Mapping · Coronado, CABuilt 2009 · S/N 4617 N244CPAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2010 · S/N 7036 N244SHAir Methods LLC · Greenwood Village, COBuilt 2015 · S/N 8157 N245AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7154 N245NEAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 21465 N246NENew England Life Flight Inc DBA · Bedford, MABuilt 2023 · S/N 21215 N247KD130h LLC · Springville, UTBuilt 2013 · S/N 7758 N247NENew England Life Flight Inc DBA · Bedford, MABuilt 2024 · S/N 21291 N249AHAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9878 N250AMAir Methods LLC · Greenwood Village, COBuilt 2025 · S/N 9741 N252TFFertitta Entertainment Holdings LLC · Houston, TXBuilt 2019 · S/N 8665 N253AHAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 9973 N253LFAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7158 N254AHAirbus Helicopters Inc · Grand Prairie, TXBuilt 2026 · S/N 21490 N254DMBarnyard LLC · Missoula, MTBuilt 2022 · S/N 9211 N254GRMed-Trans Corp · Denton, TXBuilt 2025 · S/N 9742 N255LFAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7140 N255PJArk Aviation LLC · Central City, KYBuilt 2018 · S/N 8595 N255RMCgcpr LLC · Canovanas, PRBuilt 2009 · S/N 4855 N25740Arrow Aviation Company LLC · Broussard, LAS/N 760732 N257AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7203 N259AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7050 N259DVRdv Leasing LLC · Grand Rapids, MIBuilt 2021 · S/N 21019 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 N265BCBroward County Sheriffs Office · Fort Lauderdale, FLBuilt 2024 · S/N 21155 N267AMAir Methods LLC · Greenwood Village, COBuilt 2011 · S/N 7215 N267LALapd Air Support Division · Los Angeles, CABuilt 2017 · S/N 8267 N267RCBank Of Utah Trustee · Salt Lake City, UTS/N 7393 N268BCBroward County Sheriffs Office · Fort Lauderdale, FLBuilt 2024 · S/N 21212 N26HXNs Air Leasing LLC · Wilmington, DEBuilt 2007 · S/N 4385 N270PWTexas Parks And Wildlife Department · Austin, TXBuilt 2023 · S/N 9374 N273AMAir Methods LLC · Greenwood Village, COBuilt 2003 · S/N 0273 N274CCVertical Aviation No 1 LLC · Miami, FLBuilt 2022 · S/N 21114 N275PCSouthern Company Services Inc · Atlanta, GABuilt 2024 · S/N 21265 N277FXFlexjet Vertical Lift LLC · Stratford, CTBuilt 2007 · S/N 760676 N278FXFlexjet Vertical Lift LLC · Stratford, CTBuilt 2008 · S/N 760750 N279AMAir Methods LLC · Greenwood Village, COS/N 4685 N282ZZAvex Xviii LLC · Fort Lauderdale, FLBuilt 2021 · S/N 21012 N2907ADepartment Of Homeland Security · Washington, DCBuilt 2022 · S/N 9216 N295JAb Air Ltd · Canton, OHBuilt 2018 · S/N 8510 N296SDepartment Of Homeland Security · Washington, DCBuilt 2020 · S/N 8850 N296WAirbus Helicopters Inc · Grand Prairie, TXBuilt 2025 · S/N 9717 N29GFAirman Helicopter Inc · Fort Lauderdale, FLBuilt 2023 · S/N 9523 N2BTBt T2 LLC · Missoula, MTBuilt 2023 · S/N 21195 N2NKAir Base LLC · Jupiter, FLBuilt 2023 · S/N 21199 N2SWEcho Matrix LLC · Bentonville, ARBuilt 2019 · S/N 8746

Back to AD 2016-25-13