Skip to content

Registered aircraft · 159

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

N195LLIndiana University Health Inc · Indianapolis, INBuilt 2008 · S/N 9226 N198LLMetro Aviation Inc · Shreveport, LABuilt 2008 · S/N 9158 N240SFOsf Aviation LLC · Peoria, ILBuilt 2010 · S/N 9403 N261MHMetrohealth System · Cleveland, OHBuilt 2009 · S/N 9250 N262MHMetrohealth System · Cleveland, OHS/N 9278 N263MHMetrohealth System · Cleveland, OHBuilt 2009 · S/N 9311 N266MHMetro Aviation Inc · Shreveport, LABuilt 2023 · S/N 9877 N267MHMetro Aviation Inc · Shreveport, LABuilt 2023 · S/N 9879 N273NEMetro Aviation Inc · Shreveport, LABuilt 2013 · S/N 9586 N304MECenter For Emergency Medicine Western Pennsylvania · West Mifflin, PAS/N 9097 N307MECenter For Emergency Medicine Western Pennsylvania · West Mifflin, PAS/N 9100 N340SFOsf Aviation LLC · Peoria, ILBuilt 2010 · S/N 9411 N365UCAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 9246 N373LFWest Penn Allegheny Foundation LLC · Pittsburgh, PABuilt 2006 · S/N 9099 N381MSAir Methods LLC · Greenwood Village, COS/N 9293 N390FDReach Air Medical Services LLC · Santa Rosa, CABuilt 2005 · S/N 9078 N399PHPhi Health LLC · Tempe, AZFirst renewal noticeBuilt 2008 · S/N 9224 N39VATriple M Leasing LLC · Shreveport, LABuilt 2010 · S/N 9384 N3PDSuffolk County Police Dept · Yaphank, NYBuilt 2006 · S/N 9094 N402CNChildren'S Hospital & Medical Center DBA · Omaha, NEBuilt 2013 · S/N 9570 N406BCMetro Aviation Inc · Shreveport, LABuilt 2020 · S/N 9863 N406GFMetro Aviation Inc · Shreveport, LABuilt 2023 · S/N 9880 N440SFOsf Aviation LLC · Peoria, ILBuilt 2011 · S/N 9457 N445CHEgleston Childrens Hospital At Emory Univ Inc DBA · Atlanta, GABuilt 2015 · S/N 9729 N445DUMetro Aviation Inc · Shreveport, LABuilt 2019 · S/N 9827 N448CHMetro Aviation Inc · Shreveport, LABuilt 2011 · S/N 9448 N452MHCharlotte Mecklenburg Hospital Authority DBA · Charlotte, NCBuilt 2007 · S/N 9122 N453MHMemorial Hermann Health System · Houston, TXBuilt 2007 · S/N 9136 N455MHMemorial Hermann Health System · Houston, TXBuilt 2008 · S/N 9161 N456TKMemorial Hermann Health System · Houston, TXBuilt 2007 · S/N 9130 N45UHUniversity Of Utah · Salt Lake City, UTBuilt 2012 · S/N 9529 N46UHUniversity Of Utah · Salt Lake City, UTBuilt 2017 · S/N 9800 N474LFWest Penn Allegheny Health System Inc · Pittsburgh, PABuilt 2009 · S/N 9301 N47UHUniversity Of Utah · Salt Lake City, UTBuilt 2015 · S/N 9601 N480LFGeisinger Medical Center · Danville, PABuilt 2012 · S/N 9502 N481LFGeisinger Medical Center · Danville, PABuilt 2010 · S/N 9392 N482LFGeisinger Medical Center · Danville, PABuilt 2007 · S/N 9118 N483LFGeisinger Medical Center · Danville, PABuilt 2007 · S/N 9133 N484LFGeisinger Medical Center · Danville, PABuilt 2009 · S/N 9259 N485ECPitt County Memorial Hospital Inc · Greenville, NCBuilt 2010 · S/N 9348 N485LFGeisinger Medical Center · Danville, PABuilt 2013 · S/N 9614 N487LFGeisinger Medical Center · Danville, PABuilt 2009 · S/N 9255 N488LFSt Lukes University Health Network · Danville, PABuilt 2010 · S/N 9377 N48SEPhi Health LLC · Tempe, AZBuilt 2005 · S/N 9071 N491HCBank Of Utah Trustee · Salt Lake City, UTBuilt 2023 · S/N 9878 N492HCTvpx Aircraft Solutions Inc Trustee · North Salt Lake, UTBuilt 2018 · S/N 9805 N507MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2012 · S/N 9507 N509CHChildrens Hospital Colorado · Aurora, COBuilt 2023 · S/N 9881 N522MECenter For Emergency Medicine Of Western Pa · West Mifflin, PABuilt 2012 · S/N 9522 N523ECPitt County Memorial Hospital Inc · Greenville, NCBuilt 2022 · S/N 9876

Back to AD 2011-21-13