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.

N107LCIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 2007 · S/N 31074 N109DRBristow LLC · Lake Charles, LAS/N 31311 N116TGLeonardo Helicopters US Corp · Philadelphia, PAS/N 41630 N118JMMjm Aviation LLC · Piscataway, NJBuilt 2010 · S/N 41251 N119MWBristow LLC · Lake Charles, LABuilt 2012 · S/N 41307 N12MQArrow Aviation Company LLC · Broussard, LAS/N 31041 N139Eurotec Vertical Flight Solutions LLC · Eudora, KSBuilt 2009 · S/N 31229 N1392CRegistered aircraftBuilt 2025 · S/N 41602 N139AKTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2019 · S/N 41565 N139BAgustawestland Philadelphia Corp · Philadelphia, PAS/N 41628 N139DERegistered aircraftBuilt 2013 · S/N 41334 N139EXBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 31851 N139FWChevron USA Inc · Picayune, MSBuilt 2005 · S/N 31022 N139HHoneywell Aerospace US LLC · Phoenix, AZBuilt 2007 · S/N 31101 N139HFTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2005 · S/N 31021 N139HSAircraft Trustee Services Inc Trustee · Dover, DEBuilt 2005 · S/N 31016 N139PHPhi Aviation LLC · Lafayette, LAS/N 41253 N139TPBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 41409 N139WTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2025 · S/N 41612 N140EVSuperior Aviation Solutions LLC · Mooresville, NCBuilt 2005 · S/N 31025 N140PHPhi Aviation LLC · Lafayette, LABuilt 2010 · S/N 41254 N141PHPhi Aviation LLC · Lafayette, LAS/N 41266 N146PHPhi Aviation LLC · Lafayette, LABuilt 2011 · S/N 41280 N149DHEra Leasing LLC · Houston, TXBuilt 2007 · S/N 41004 N149PHPhi Aviation LLC · Lafayette, LABuilt 2012 · S/N 41303 N151PHPhi Aviation LLC · Lafayette, LABuilt 2012 · S/N 41312 N152PHPhi Aviation LLC · Lafayette, LABuilt 2012 · S/N 41316 N153PHPhi Aviation LLC · Lafayette, LABuilt 2012 · S/N 41317 N15460Variety Childrens Hospital DBA · Miami, FLBuilt 2012 · S/N 41323 N156JSEra Leasing LLC · Lake Charles, LABuilt 2007 · S/N 41003 N159RBBristow LLC · Lake Charles, LABuilt 2012 · S/N 41281 N181JPowderbird LLC · Providence, RIBuilt 2018 · S/N 41544 N1NJState Of New Jersey · Trenton, NJBuilt 2011 · S/N 41242 N221VFAgustawestland Philadelphia Corp · Philadelphia, PAS/N 41633 N223KRBank Of Utah Trustee · Salt Lake City, UTBuilt 2013 · S/N 41340 N2314National Nuclear Security Administration · Las Vegas, NVBuilt 2024 · S/N 41585 N2415National Nuclear Security Administration · Las Vegas, NVBuilt 2024 · S/N 41586 N247GC10x Whirlybird LLC · Aventura, FLBuilt 2010 · S/N 41252 N276HSBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 41517 N27RTRegistered aircraftBuilt 2022 · S/N 41582 N282EFLeonardo Helicopters US Corp · Philadelphia, PAS/N 41641 N283EFLeonardo Helicopters US Corp · Philadelphia, PAS/N 41650 N29RTRegistered aircraftBuilt 2023 · S/N 41583 N301FDLos Angeles Fire Department · Van Nuys, CABuilt 2019 · S/N 41557 N302FDLos Angeles City · Van Nuys, CABuilt 2011 · S/N 41239 N303FDLos Angeles City · Van Nuys, CABuilt 2008 · S/N 41012 N304FDCity Of Los Angeles · Van Nuys, CABuilt 2017 · S/N 41528 N305FDCity Of Los Angeles · Van Nuys, CABuilt 2008 · S/N 41009 N308GCLeonardo Helicopters US Corp · Philadelphia, PAS/N 41629 N30WXTvpx Ars Inc Trustee · North Salt Lake, UTBuilt 2009 · S/N 41223

Back to AD 2008-14-02 R1