Skip to content

Registered aircraft · 180

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:2022-06-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:2022-06-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:2022-06-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:2022-06-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:2022-06-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:2022-06-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.

N192LLIndiana University Health Inc · Indianapolis, INBuilt 2009 · S/N 9288 N193LLIndiana University Health Inc · Indianapolis, INBuilt 2010 · S/N 9353 N194LLIndiana University Health Inc · Indianapolis, INBuilt 2010 · S/N 9357 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 N343PHPhi Aviation LLC · Lafayette, LABuilt 2017 · S/N 20120 N365UCAir Methods LLC · Greenwood Village, COBuilt 2009 · S/N 9246 N366GTGth & Tth Holdings LLC · Redwood City, CABuilt 2018 · S/N 20216 N373LFWest Penn Allegheny Foundation LLC · Pittsburgh, PABuilt 2006 · S/N 9099 N375AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 20227 N376AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2018 · S/N 20239 N377AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 20254 N378AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 20260 N379AHBank Of Utah Trustee · Salt Lake City, UTBuilt 2019 · S/N 20263 N381MSAir Methods LLC · Greenwood Village, COS/N 9293 N390FDReach Air Medical Services LLC · Santa Rosa, CABuilt 2005 · S/N 9078 N393PHPhi Aviation LLC · Lafayette, LABuilt 2017 · S/N 20122 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

Back to AD 2022-06-13