Skip to content

Registered aircraft · 171

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

N1079UTurbines Ltd · West Point, NEBuilt 1980 · S/N 31122 N107LCIntegrity Aircraft Title Holdings LLC · Portland, ORBuilt 2007 · S/N 31074 N109DRBristow LLC · Lake Charles, LAS/N 31311 N118JMMjm Aviation LLC · Piscataway, NJBuilt 2010 · S/N 41251 N119MWBristow LLC · Lake Charles, LABuilt 2012 · S/N 41307 N119WGHigh Performance Helicopters Corp · Crestline, CABuilt 2005 · S/N 14502 N121CMSpace Coast Aircraft Co · Merritt Island, FLBuilt 1993 · S/N 208B0336 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 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 N141MHCinema Aircraft Executive Transportation LLC · Las Vegas, NVBuilt 1997 · S/N 760465 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 N159CMMomentum Foundation Inc · Tullahoma, TNBuilt 1987 · S/N 760333 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 N212HBBritt Christopher Charles · Bryan, TXBuilt 1982 · S/N 31214 N212HPCorpat Inc · Missoula, MTBuilt 1979 · S/N 30951 N212YS76b LLC · New York, NYBuilt 1989 · S/N 760357 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 N249HVertol Systems Co Inc · Destin, FLBuilt 1993 · S/N 35061 N276HSBank Of Utah Trustee · Salt Lake City, UTBuilt 2016 · S/N 41517 N27RTRegistered aircraftBuilt 2022 · S/N 41582 N280TRAircraft Guaranty Corporation Trustee · Oklahoma City, OKBuilt 1988 · S/N 760344 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

Back to AD 2013-03-14