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.

N639MCChevron USA Inc · Picayune, MSBuilt 2012 · S/N 41288 N639MMChevron USA Inc · Picayune, MSBuilt 2009 · S/N 41216 N639NAChevron USA Inc · Picayune, MSBuilt 2013 · S/N 41326 N639WWChevron USA Inc · Picayune, MSBuilt 2009 · S/N 41229 N675WBWrbc Transportation Inc · Greenwich, CTBuilt 2015 · S/N 41504 N690BBAgustawestland Philadelphia Corp · Philadelphia, PAS/N 41636 N696BBCsc Delaware Trust Co Trustee · Wilmington, DEBuilt 2020 · S/N 41575 N697BBLeonardo Helicopters US Corp · Philadelphia, PAS/N 41638 N697RSLeonardo Helicopters US Corp · Philadelphia, PAS/N 31035 N700JJohnson & Johnson Finance Corp · New Brunswick, NJBuilt 2016 · S/N 41412 N704FSFlo Sun Aircraft Inc · West Palm Beach, FLBuilt 2014 · S/N 31559 N710EPLeonardo Helicopters US Corp · Philadelphia, PAS/N 41640 N726MDBristow LLC · Lake Charles, LABuilt 2013 · S/N 41320 N730VMBristow LLC · Lake Charles, LABuilt 2014 · S/N 41362 N739BGBristow U S LLC · New Iberia, LABuilt 2013 · S/N 41350 N763EPLeonardo Helicopters US Corp · Philadelphia, PAS/N 41643 N770LZRbhc LLC · Rollins, MTBuilt 2014 · S/N 41364 N7NJState Of New Jersey · Trenton, NJBuilt 2011 · S/N 41264 N805KGRotorkraft Trust · Wilmington, DEBuilt 2015 · S/N 41503 N811TABristow LLC · Lake Charles, LABuilt 2011 · S/N 41269 N813DGBristow LLC · Lake Charles, LABuilt 2006 · S/N 31032 N819JABristow LLC · Lake Charles, LAS/N 31322 N82NYLeonardo Helicopters US Corp · Philadelphia, PAS/N 41631 N83MLHampton Airways Inc · Sellersburg, INBuilt 2013 · S/N 41356 N855AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 41547 N855JRBoeing Co · Ridley Park, PABuilt 2026 · S/N 41827 N856AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 41553 N856JRAgustawestland Philadelphia Corp · Philadelphia, PABuilt 2026 · S/N 41828 N857AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 41554 N857JRLeonardo Helicopters US Corp · Philadelphia, PABuilt 2026 · S/N 41829 N858AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 31850 N858JRLeonardo Helicopters US Corp · Philadelphia, PABuilt 2026 · S/N 41830 N859AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 41556 N859JRLeonardo Helicopters US Corp · Philadelphia, PAS/N 41831 N860AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 31856 N860JRLeonardo Helicopters US Corp · Philadelphia, PAS/N 41832 N861AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 31867 N861JRLeonardo Helicopters US Corp · Philadelphia, PAS/N 41833 N862AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 31876 N862JRLeonardo Helicopters US Corp · Philadelphia, PAS/N 41834 N863AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 31891 N863JRLeonardo Helicopters US Corp · Philadelphia, PAS/N 41835 N864AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2020 · S/N 31892 N864JRLeonardo Helicopters US Corp · Philadelphia, PAS/N 41836 N865JRLeonardo Helicopters US Corp · Philadelphia, PAS/N 41837 N866JRLeonardo Helicopters US Corp · Philadelphia, PAS/N 41838 N8CPRegistered aircraftBuilt 2025 · S/N 41608 N911ARMiami Dade Fire Rescue · Miami, FLBuilt 2020 · S/N 41567 N911FDMiami-Dade Fire Rescue Department · Miami, FLBuilt 2020 · S/N 41568 N911FKMonroe County Florida · Key West, FLBuilt 2025 · S/N 41606

Back to AD 2008-14-02 R1