Skip to content

Registered aircraft · 353

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-21') 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-21') 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-21')
    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-21')
  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-21')
  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-21')
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.

N162AECharlotte-Mecklenburg Hospital Authority · Charlotte, NCBuilt 2013 · S/N 1125 N162MWBank Of Utah Trustee · Salt Lake City, UTBuilt 2000 · S/N 0162 N163BFAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0671 N197JGlobal Aircraft Trust Inc Trustee · Cheyenne, WYBuilt 2004 · S/N 11616 N209JBChevron USA Inc · Picayune, MSBuilt 2024 · S/N 22454 N20ANChevron USA Inc · Picayune, MSBuilt 2024 · S/N 22453 N211FXCounty Of Fairfax · Fairfax, VABuilt 2010 · S/N 57004 N212FXCounty Of Fairfax · Fairfax, VABuilt 2011 · S/N 57055 N217FArrow Aviation Company LLC · Broussard, LABuilt 2005 · S/N 0438 N217TArrow Aviation Company LLC · Broussard, LABuilt 2005 · S/N 0441 N226SABennett Aviation LLC · Elmhurst, ILBuilt 2007 · S/N 0559 N228BJBristow LLC · Lake Charles, LABuilt 2011 · S/N 0982 N228MTAir Evac Ems Inc · O Fallon, MOBuilt 2010 · S/N 0908 N230AMAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0540 N235DHMetro Aviation Inc · Shreveport, LABuilt 1999 · S/N 0058 N235LLMercy Hospital Springfield · Springfield, MOBuilt 2008 · S/N 0662 N238AMAir Methods LLC · Greenwood Village, COBuilt 2000 · S/N 11084 N23SHIndiana Helicopters LLC · Fort Wayne, INBuilt 2012 · S/N 22285 N244AMAir Methods LLC · Greenwood Village, COBuilt 2007 · S/N 0610 N247HYKohilo LLC · Hillsborough, CABuilt 2022 · S/N 11158 N251HCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2010 · S/N 22221 N252SABennett Aviation LLC · Elmhurst, ILBuilt 2008 · S/N 0707 N253AMAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0663 N253MTMed-Trans Corp · Denton, TXBuilt 2014 · S/N 1153 N253SABennett Aviation LLC · Elmhurst, ILBuilt 2010 · S/N 0890 N259AZUmb Bank Na Trustee · Salt Lake City, UTBuilt 2025 · S/N 22469 N25JJOtu Aerospace LLC · Austin, TXBuilt 2007 · S/N 22043 N261AMAir Methods LLC · Greenwood Village, COBuilt 2008 · S/N 0734 N261HCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2011 · S/N 22247 N26SHIndiana Helicopters LLC · Fort Wayne, INBuilt 2016 · S/N 22360 N271HCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2011 · S/N 22250 N281HCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2013 · S/N 22310 N28NMNorth Memorial Healthcare · Brooklyn Center, MNBuilt 2005 · S/N 22003 N291HCIntermountain Medical Transport LLC · Salt Lake City, UTBuilt 2013 · S/N 22313 N298RN962heli LLC · Edmond, OKBuilt 2004 · S/N 11618 N2ENEurotec Vertical Flight Solutions LLC · Eudora, KSS/N 11091 N301PHPhi Health LLC · Tempe, AZBuilt 2004 · S/N 0355 N302NMBristow LLC · Lake Charles, LABuilt 2011 · S/N 0987 N302PHPhi Health LLC · Tempe, AZBuilt 2004 · S/N 0364 N303PHPhi Health LLC · Tempe, AZBuilt 2004 · S/N 0372 N304PHPhi Health LLC · Tempe, AZBuilt 2005 · S/N 0386 N305PHPhi Health LLC · Tempe, AZBuilt 2005 · S/N 0395 N308PHPhi Health LLC · Tempe, AZBuilt 2005 · S/N 0401 N309PHPhi Health LLC · Tempe, AZBuilt 2005 · S/N 0403 N30EHHelinet Aviation Services LLC · Van Nuys, CABuilt 1999 · S/N 11029 N30RXReach Air Medical Services LLC · Santa Rosa, CABuilt 2011 · S/N 1001 N311MFQuad City Helicopter Emergency Medical Service · Davenport, IABuilt 2012 · S/N 1069 N311PHPhi Health LLC · Tempe, AZBuilt 2005 · S/N 413 N312PHPhi Health LLC · Tempe, AZBuilt 2005 · S/N 0404 N312RXReach Air Medical Services LLC · Mcclellan, CABuilt 2013 · S/N 1099

Back to AD 2013-03-21