Skip to content

AD 2008-14-02 R1

Registered aircraft · 165

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:2008-14-02-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:2008-14-02-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:2008-14-02-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:2008-14-02-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:2008-14-02-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:2008-14-02-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.

N311MQArrow Aviation Company LLC · Broussard, LAS/N 31532 N319SBWg Aviation Heli I LLC · Miami, FLBuilt 2023 · S/N 41587 N328SHBristow LLC · Lake Charles, LABuilt 2012 · S/N 41309 N346MRTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTS/N 31046 N363TRBank Of Utah Trustee · Salt Lake City, UTBuilt 2025 · S/N 41618 N36SGAstra Beta Helicopter LLC · Newburgh, NYBuilt 2010 · S/N 41246 N379EFAgustawestland Philadelphia Corp · Philadelphia, PANon-citizen corporation, flight hours not reportedS/N 41634 N381MDMaryland State Police Aviation Command · Middle River, MDBuilt 2012 · S/N 41276 N382MDMaryland State Police Aviation Command · Middle River, MDBuilt 2012 · S/N 41287 N383MDMaryland State Police Aviation Command · Middle River, MDBuilt 2012 · S/N 41289 N384MDMaryland State Police Aviation Command · Middle River, MDBuilt 2013 · S/N 41290 N385MDMaryland State Police Aviation Command · Middle River, MDBuilt 2013 · S/N 41291 N386MDMaryland State Police Aviation Command · Middle River, MDBuilt 2013 · S/N 41292 N387MDMaryland State Police Aviation Command · Middle River, MDBuilt 2013 · S/N 41327 N388MDMaryland State Police Aviation Command · Middle River, MDBuilt 2013 · S/N 41336 N389MDMaryland State Police Aviation Command · Middle River, MDBuilt 2013 · S/N 41338 N390MDMaryland State Police Aviation Command · Middle River, MDBuilt 2014 · S/N 41377 N39EQAstra Beta Aw139 LLC · Newburgh, NYBuilt 2025 · S/N 41622 N39WERegistered aircraftBuilt 2019 · S/N 41555 N3NJState Of New Jersey · Trenton, NJS/N 41293 N3WTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 41211 N415JHBristow LLC · Lake Charles, LABuilt 2009 · S/N 41224 N428NELeonardo Helicopters US Corp · Philadelphia, PABuilt 2007 · S/N 41001 N42EETvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2023 · S/N 41581 N432MRArrow Aviation Company LLC · Broussard, LAS/N 31042 N438HBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 41598 N439HBank Of Utah Trustee · Salt Lake City, UTBuilt 2024 · S/N 41597 N455LHLeonardo Helicopters US Corp · Philadelphia, PAS/N 31051 N455VBRegistered aircraftN-number assigned, not yet registeredS/N 41637 N4FNBank Of Utah Trustee · Salt Lake City, UTBuilt 2022 · S/N 41579 N503SHBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 41384 N50HRSeminole Tribe Of Florida · Hollywood, FLBuilt 2017 · S/N 41531 N524JDBristow LLC · Lake Charles, LABuilt 2012 · S/N 41301 N531JRBoeing Co · Ridley Park, PABuilt 2024 · S/N 41814 N551HYMr Aviation LLC · Kearny, NJBuilt 2017 · S/N 31771 N553RDBristow LLC · Lake Charles, LABuilt 2014 · S/N 41369 N566JRBoeing Co · Ridley Park, PABuilt 2026 · S/N 41825 N567JRBoeing Co · Ridley Park, PABuilt 2026 · S/N 41826 N5NJState Of New Jersey · Ewing, NJBuilt 2011 · S/N 41260 N603PWBristow LLC · Lake Charles, LABuilt 2010 · S/N 31309 N614CJSuffolk Av LLC · Boston, MABuilt 2024 · S/N 32041 N615DJEra Leasing LLC · Houston, TXS/N 41261 N615EPLeonardo Helicopters US Corp · Philadelphia, PAS/N 41644 N629RTIntegrity Aircraft Title Holdings LLC · Portland, ORS/N 31269 N638MFR O P Aviation Inc · Morristown, NJBuilt 2014 · S/N 41392 N639BGBristow US LLC · New Iberia, LABuilt 2013 · S/N 41343 N639CFChevron U S A Inc · Picayune, MSBuilt 2025 · S/N 41604 N639DSChevron USA Inc · Picayune, MSBuilt 2011 · S/N 41262 N639GGChevron USA Inc · Picayune, MSBuilt 2012 · S/N 41308 N639JKChevron U S A Inc · Picayune, MSBuilt 2025 · S/N 41607

Back to AD 2008-14-02 R1